MS Access Log in Form

[daleshei]

I found a user log in form online for MS Access which is very good which I've started using. Username (listbox) and password (textbox) are linked to the Users Table (containing usernames & passwords).

What I want to do is create a user log which records when a user logs in including date and time to be written in a new Table with the following fields: Username (based on the drop down list box, Date and time.

Hope it makes sense. Thanx in advance.

D

 

[Remou]

Have a look at Append queries.

 

[PHV]

And the Now() function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[daleshei]

Finally got it working, thank you.

 

[CoolFactor]

Daleshei,

I was wondering if good get a copy of that user online form that you have.

 

[CoolFactor]

Daleshei,

I was wondering if good get a copy of that user online form that you have.

 

[daleshei]

Sorry CoolFactor for the late reply, here's the website for the log in form

http://www.databasedev.co.uk/login.html

D