I need to adapt Allen Browne's Audit Trail solution: http://allenbrowne.com/AppAudit.html
to cater for the situation where more than 1 person users the same pc, accessing the database.
In this case, in addition to the NetworkUserName(), I need to write the name of user (or UserID) who has logged-in to the audit table. The UserName would be obtained from frmLogin.cboUser.column(1)
. The UserID would be obtained from frmLogin.cboUser.column(0)
Your Assistance would be greatly appreciated.