'How to create a user Login account in MS Access VBA | Bytes (2024)

Home Posts Topics Members FAQ

Emmanuel Ayivi

'How to create a user Login account in MS Access VBA | Bytes (1) 19 New Member

Please the SQL query is saying a error thus Expected end of statement can I know is wrong with it?

strSQLDetails = "SELECT tFD.* " & _
"FROM [tblFeesDetails] AS tFD" & _
" INNER JOIN" & _
" (SELECT LAST([Insect_Date and Time]) AS [LastDT]" & _
" FROM [tblFeesDetails]" & _
" WHERE ([GroupID] = '%G'")) AS sQ" & _
" ON tFD.[Insect_Date and Time] = sQ.LastDT " & _
"WHERE (tFD.GroupID = '%G'")
strSQLDetails = Replace(strSQLDetails, "%G", mGroupID)

Mar 17 '11 #1

3 'How to create a user Login account in MS Access VBA | Bytes (2) 2321 'How to create a user Login account in MS Access VBA | Bytes (3)

hype261

207 'How to create a user Login account in MS Access VBA | Bytes (4) New Member

I can't see an obvious error in your syntax, but generally what I do in this situation is to copy the query and go to the query designer and put it on sql mode and paste it in. The query designer gives must better error messages on what is the problem than VBA.

Mar 17 '11 #2

reply

Emmanuel Ayivi

19 'How to create a user Login account in MS Access VBA | Bytes (5) New Member

I copied the SQL query and pasted it in the designer and it says "Expected end of statement. so I tried going through but could not see anything wrong with it but the saying the is an error

strSQLDetails = "SELECT tFD.* " & _
"FROM [tblFeesDetails] AS tFD" & _
" INNER JOIN" & _
" (SELECT LAST([Insect_Date and Time]) AS [LastDT]" & _
" FROM [tblFeesDetails]" & _
" WHERE ([GroupID] = '%G'")) AS sQ" & _
" ON tFD.[Insect_Date and Time] = sQ.LastDT " & _
"WHERE (tFD.GroupID = '%G'")

Mar 17 '11 #3

reply

Rabbit

12,516 'How to create a user Login account in MS Access VBA | Bytes (7) Recognized Expert Moderator MVP

The code you pasted into the SQL query editor is VBA code. That's not valid SQL.

Also, are you sure it's supposed to be = "%G" and not Like "%G"?

Mar 17 '11 #4

reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 2262

Regenerating ASPNET Login Account

by: Iced Crow |last post by:

How do you regenerate the ASP_NET login account? The password got changed which hosed everything. I can no longer see my web services and need to reset the ASP account. How do I do this? Thanks ~IC

ASP / Active Server Pages

4 3586

Newbee question - why no create user in DB2 ?

by: cmc |last post by:

Hi, I 'm new to DB2 (from Oracle background) and have some fundamental question. In Oracle, you create user account "within the database" to let user to logon to the database. There is no tie between the unix account (or other operating system) and the oracle user account - you can logon to the server machine dose not mean you can logon...

DB2 Database

14 6144

How to change the account that ASP.NET uses

by: Mr.KisS |last post by:

Hi, How to change the account that ASP.NET uses for this virtual directory to one that has rights to the SQL Server box. Or how to use impersonation set in the Web.config file for the asp application, referring to an account that has rights to the SQL Server box.

ASP.NET

6 4154

Login/VBA script to login to Access 2000

by: cyndithomas via AccessMonster.com |last post by:

I new to Visual Basic and am struck on a issue. Have created a Login in Screen for Remote User to access and input data. Want the Remote to be able to login & access the Input Form, and Manager to Login to another screen to view data. Form 1 is rmFieldReq (Remote Users Form) Form 2 is frmREquests (Manager Form) Below is my Code

Microsoft Access / VBA

871

Error while creating a new user login, using c#

by: mig |last post by:

Hi I was writing a piece of code to create a new user login on my machine, which runs vista. I get this error: "General Access Denied Error" at newUser.CommitChanges() in the following code: public static void AddUser(string userName, string password) { DirectoryEntry activeDirectory = new DirectoryEntry("WinNT://" +...

.NET Framework

1090

Create user within the Login Control

by: TheDude5B |last post by:

Hi, I have a problem with existing customers from an old site, coming to my new asp.net 2.0 site with the user roles and membership, and trying to login with their old details. As you know, the new built in membership encrypts passwords (I know you can use the system without encrypting the passwords, but this what i have unfortunetaly...

ASP.NET

1590

DirectoryEntry without using admin user: how to check if account'sexpired

by: Big Charles |last post by:

Hello, Programming in VS2003-ASP.NET 1.1, I have this problem: Using DirectoryEntry and without any admin user, how can I check if a domain account, that try to login, has expired? Scenario: User load web application and login using account and password of the Active Directory. But user account of ActiveDirectory has expired (or password...

.NET Framework

1 1336

i need a help in C Sharp "Create a login pange"

by: nazmyonline |last post by:

i hv created a login form on C sharp .net i need 2 connect this form to MS Access database . there s a table user account from there i hv created 2 column " Username ,password " whn i press the login button check the database n i need 2 login i hv uploaded dat application here plz help me .. its very important 4 me .. i hope i vl...

C# / C Sharp

5 1804

How to dynamically login into a client computer

by: reachkars |last post by:

Hi, I need to know if it is possible in .Net to dynammically login or enter credentials or unlock a locked machine through another machine which has Admin access(logged on by an administrator). The reason I need this is, Am working on a project where in I assign unique id's to set of computer users, For eg:

.NET Framework

1 1814

Custom user login system edition

by: munkee |last post by:

I have modified Richard Rensel's Security Demo 2000 in order to produce a custom user login system. One of the aspects which I am succesfully using is the basic user grouping level: Access ID - Access title - Access description. This allows me to check the allowed access a user has when opening a form and enabling/disabling certain...

Microsoft Access / VBA

7328

What is ONU?

by: marktang |last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7251

Changing the language in Windows 10

by: Hystou |last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

7474

Problem With Comparison Operator <=> in G++

by: Oralloy |last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

1 7228

The easy way to turn off automatic updates for Windows 10/11

by: Hystou |last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

5775

AI Job Threat for Devs

by: agi2029 |last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

4811

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam |last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3305

Windows Forms - .Net 8.0

by: adsilva |last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1700

transfer the data from one system to another through ip address

by: 6302768590 |last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1 887

How to add payments to a PHP MySQL app.

by: muto222 |last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisem*nts and analytics tracking please visit the page.

'How to create a user Login account in MS Access VBA | Bytes (2024)

References

Top Articles
Latest Posts
Article information

Author: Barbera Armstrong

Last Updated:

Views: 5951

Rating: 4.9 / 5 (59 voted)

Reviews: 90% of readers found this page helpful

Author information

Name: Barbera Armstrong

Birthday: 1992-09-12

Address: Suite 993 99852 Daugherty Causeway, Ritchiehaven, VT 49630

Phone: +5026838435397

Job: National Engineer

Hobby: Listening to music, Board games, Photography, Ice skating, LARPing, Kite flying, Rugby

Introduction: My name is Barbera Armstrong, I am a lovely, delightful, cooperative, funny, enchanting, vivacious, tender person who loves writing and wants to share my knowledge and understanding with you.