Append query in VBA triggered by a form event for simple audit trail.

's Computer Specifications

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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Append query in VBA triggered by a form event for simple audit trail.	Gabe	Microsoft Access Queries	0	28th Jul 2011 04:04 PM
SecPol Audit Policy: Diff between "Audit account logon events" and "Audit logon events" ?	Sebastian Kaist	Windows XP Help	2	13th Mar 2009 04:37 PM
SecPol Audit Policy: Diff between "Audit account logon events" and "Audit logon events" ?	Sebastian Kaist	Windows XP General	0	13th Mar 2009 08:06 AM
Append Query in VBA - to append VBA variable values to Access tabl	=?Utf-8?B?QWdlbnQgRGFnbmFtaXQ=?=	Microsoft Access VBA Modules	4	1st Nov 2006 05:25 PM
Open a query window from a VBA sub triggered from a form	Roger Withnell	Microsoft Access	3	20th Aug 2005 01:48 PM