How to To log data entry form user name in MS Access database using VBA

[siamandm]

Hello All,

if I have a login form, to login to a database which multiple users are using it...
how to log the user name for the new records inserted or modified by this user with the time stamp using VBA codes


Regards
Siyamand

[HansV]

Do you keep the login form open? If not, do you store the login name somewhere?

[siamandm]

We have a table for the username and password which use for login to the database
The form will be closed after success login

[HansV]

How do we know the username when the login form has been closed?

[siamandm]

Im not sure but usually when you login to a system the login screen disappear, it will be closed or minimized?

[HansV]

If you want to log the username, we have to know the username...

[siamandm]

So what you advise?

[HansV]

You have to store the username somewhere, for example a text box on a form that remains open, or in a table...

[siamandm]

Aha so we can put a label that shows the logged in user name

[HansV]

That's one possibility.

Do you want to log the username and timestamp in each table itself, or do you want to use a separate table that contains these data for all tables that you want to log?

[siamandm]

I believe the second option os more practical having one table for users log

Regards

[HansV]

See for exampleAudit Trail using Data Macros