I'm putting together a dbase in Access 2007 that has a logon page. I have a table with users' information (logon, password, etc.). I've created a form for users to log in from and added some code to validate it against the users' table to make sure that the password and logon matches.
Here's...
Newbie to VB here.
I have a module in a dbase that stores the user id of the person logged into the dbase.
In the logon screen, I set the value of the user id using the following codes.
lngCurrentUser = Me.UserName.Value
lngCurrentUserID = DLookup("ID", "lst_SalesRep"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.