Access problems

[Tom Lovick]

Firstly -



I need to be able to specify which form needs to be opened when a specific user logs on. So for instance I need to be able to have an administrator, supervisor and standard user to login to their groups main menu.

Secondly -

On the main menu I want it to have at the top: 'Welcome Tom Lovick' (or which ever user is logged in)

Thirdly -

I want to have the date and time on the main menus to be able to update themselves with no human interaction.

[orange]

see http://office.microsoft.com/en-us/ac...003070410.aspx for various facts

[Tom Lovick]

Thanks,

but I have the tbl_employees setup, and I have got it so I can login via a form to get to one of the main menus, and I can get it to open 2 forms for 2 different users, but not without putting the username and password into the VBA code.

I want the form to validate the username and password first and then look at the username against the users position and open the correct form based on that.

[orange]

Interesting, you didn't mention that in your first post.
Perhaps you should tell us what you want to do; what you have accomplished so far; and what the issue/problem is that you now face.

So at this point you must be getting the username and password at login.
You could have an autonumber PK in the table where you store Username and Password, then just use the PK, or set a boolean saying that the user/password combination has been validated. You could relate that to a table of users and positions.

Use the boolean to determine what form should be opened next.

Just a few thoughts.