PC Review


Reply
Thread Tools Rate Thread

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

 
 
Gabe
Guest
Posts: n/a
 
      28th Jul 2011
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.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:29 PM.