G
Gabe
I am new to Access 2002. I have a read-only customer name/address
database. I would like to create a very rudimentary "audit trail" in a
new table, that would track the following: UserID, the CustomerNumber
accessed by the user, and the date/time it was accessed. That is all.
I have set up User Security in Access so I think I have everything I
need: the user ID, the unique CustomerNumber key value from the
Customer_form which is returned from the Customer_Query, and the date/
time -- Now(). What would be the code for this? Would I use the
form_load event? My database does not have autonumber key fields. Do I
need them? I'm not getting anywhere with this and have struggled with
it for two days. I'm sure the solution is quite simple. Would greatly
appreciate any help. Thank you.
database. I would like to create a very rudimentary "audit trail" in a
new table, that would track the following: UserID, the CustomerNumber
accessed by the user, and the date/time it was accessed. That is all.
I have set up User Security in Access so I think I have everything I
need: the user ID, the unique CustomerNumber key value from the
Customer_form which is returned from the Customer_Query, and the date/
time -- Now(). What would be the code for this? Would I use the
form_load event? My database does not have autonumber key fields. Do I
need them? I'm not getting anywhere with this and have struggled with
it for two days. I'm sure the solution is quite simple. Would greatly
appreciate any help. Thank you.