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.
|
Similar Threads
