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

Discussion in 'Microsoft Access Queries' started by Gabe, Jul 28, 2011.

  1. Gabe

    Gabe Guest

    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.
     
    Gabe, Jul 28, 2011
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. jason
    Replies:
    11
    Views:
    371
    Douglas J. Steele
    Sep 12, 2003
  2. Elainie

    Audit trail

    Elainie, Jul 13, 2006, in forum: Microsoft Access Queries
    Replies:
    1
    Views:
    158
    Guest
    Jul 13, 2006
  3. jomara via AccessMonster.com

    allen brownes audit trail

    jomara via AccessMonster.com, Mar 6, 2007, in forum: Microsoft Access Queries
    Replies:
    3
    Views:
    218
    Allen Browne
    Mar 6, 2007
  4. Guest

    Help with query on Audit Trail

    Guest, Jul 26, 2007, in forum: Microsoft Access Queries
    Replies:
    0
    Views:
    188
    Guest
    Jul 26, 2007
  5. Gabe
    Replies:
    0
    Views:
    623
Loading...

Share This Page