How to capture database user name and time stamp in a table.

[shery1995]

Hi All, How can I capture the user name, date modified and time stamp in other tables from userlogin table which as users log in details?

 

[Isaac]

You might consider storing the Username in either a global variable, a TempVar, or a table, when the user first logs in.

You can then utilize that information later in code, in Audit Trail. Search forum for Audit Trail - lots of examples.
One article:

Audit Trail using Data Macros

There are different ways to do audit trails in Access. Up until Access 2010, these had to be implemented on the Form level. But Access 2010 has Data macros which operate on the Table level, so they…

scottgem.wordpress.com