I have couple of questions on setting up user login. I have a table named EmployeeList with userID and Pswd feilds. I have setup a login form with a listbox for userID and would like to verify the Pswd in my table with the one typed in, and keep the userID in memory to use in other parts of my database...

Any help would be appreciated!

Thanks
Dan

Well - I would first suggest that you use standard Access User security - that will solve a lot of your problems.

Steven

There are 10 kinds of people in the world - those who understand binary - and those with friends

Hi Steven,

Well my setup has changed, I'm told it doesn't have to be a secure database!!! The problem I'm having is i can't select a user, the list box is there but I can't select anything?

How can I retreive the user that is selected and use that in the rest of my database while they are logged in?

Dan

Dan,

First, make sure your list field is enabled and not locked. If you don't want users other than what's on your list to be chosen, make sure the Limit to List property is set to YES.

To use someone selected in one form on other forms, either create a global variable and assign your choice to that variable to use elsewhere, or keep the logon form open but hidden so that field is available to memory. Personally, I don't like to keep any forms open unless necessary so I like the former approach, not the latter.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Is there anyplace I can get info on how create a global variable and on how to close forms when another is opened?

Dan

Using Access help should do it for you, but just in case Microsoft's help is cryptic and confusing (which it tends to be), basically: Open a new module. On the top just after you see "Option Compare Database" declare your global variable, e.g.

Then in your logging in form, you set gstrLoggedUser = Me.txtLoggedUser or whoever was in that text box. To make a global constant variable, you do this:

I use the above constant a lot because there is no vbGray for text color in Access unless you use the RGB function.

Use the DoCmd.Close method, e.g.

Access help is pretty good for this one.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

One more question on this...

I've sorerd my value: gstrLoggedUser = EmployeeName.Value

In my new form I would like to call this value and when the data is entered it will update my table?

Thanks

To use the value just include it in your expression. For example,



As for putting into a table, you can put any value (whether it's a global or local one) into any table.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division