Hi,
I want to be able to track each person who logs in to the database, I thought it could be done by using the Forms On Load event to trigger this then I need to be able to read who has logged on and the time and date.
I am using Environ("username") to automatically log people on.
I have created a Form AuditLogin with fields below, I want to automatically save the data of everyone who logs on to the database
ID (Auto Number)
LoggedIn (Date /Time) Date and time the user logged in
LoggedOut (Date/Time) Date and time the user logged out
UserName (Text) Login name (username)
how can I log the information and save it to the Table
Thanks