Simple Log in screen help

[colkas]

Hi

I have a table with user id, username and position of users.

I want the users (abit like the Northwind Db) to have this screen when they log in (a form which as the user name drop down list and button for Login)

When they log in with their user name then I want that to be the currentuser and go to a selected form menu (dependant on name), so if they creat something we can see that they are the current user and for instance I can use =currentuser on reports showing their name and position).

I tried copying the Northwind but failed. I am not using a projectjust striaght forward MDB.

Can anyone help or point me in the direction if a simple step by step example.

Many Thanks

 

[DCrake]

Have you looked in the Sample Databases section or examples?

 

[colkas]

Hi

Thanks for the reply. Yes I have but and found one by yourself I believe, which I am now trying to ut into my DB. I will no doubt run into problems, still very raw with more advanced things presently

Thanks

 

[colkas]

First impressions I am running into problems... there is far to much coding. I have for example changed the user name to look at my table, that works but as soon as i click login i then get a whole host of debug problems.

Any ideas please....

 

[colkas]

Hi All

Does anyone have any ideas on this at all

I ahve tried using the access 2010 manage user and passwords and I can get this working. I use the Wizard but then when I go into the databse it just shows as Admin as current user and does not even list the users I have so I am totally lost on this one.... Basically I want

1. A log in screen so user puts in username and password (I also need to log Job Title so I assume a tble is the way)
2. Then when logged in they are the current user, not the admin.

If anyone also knows any good documentation on how to sue the manage users and passwords part of access 2010 I would appreciate that.

I am not up on coding so the easier solution the better.

Many thanks