Results 1 to 3 of 3

Thread: Audit Trail

  1. #1
    Join Date
    Oct 2014
    Posts
    268
    Provided Answers: 6

    Answered: Audit Trail

    I was hoping a fellow Access user could provide some VBA or a link to VBA that shows the steps to create an audit record. Essentially all that needs to happen is when a user makes a change to one field, contract end date, the record recreates the same record except the PK for that table updates on it's own through identity. Everything else would copy over to the next record.

    Access has two linked table coming through from SSMS 2008.

    I was think after update on the end date then start the code.

    I have SQL embedded in VBA to write to tables etc, but creating the new record is a little different from my previous task.

    Table = 40 Attribute Columns, One PK and One Fk to link back to the contract table. This is the attribute of the contract table.

    Kind regards
    V

  2. Best Answer
    Posted by Missinglinq

    "Here is an excellent tutorial on the subject:

    http://allenbrowne.com/AppAudit.html

    and another

    http://www.fontstuff.com/access/acctut21.htm

    and yet a third, form the Boys of Redmond; it states that it is for Version 2000, but can be used for all versions after that, I believe.

    http://support.microsoft.com/kb/197592

    Be warned, though, this kind of thing is never going to be a simple task, and you'll need to follow instructions/examples carefully!

    Linq ;0)>"


  3. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Here is an excellent tutorial on the subject:

    http://allenbrowne.com/AppAudit.html

    and another

    http://www.fontstuff.com/access/acctut21.htm

    and yet a third, form the Boys of Redmond; it states that it is for Version 2000, but can be used for all versions after that, I believe.

    http://support.microsoft.com/kb/197592

    Be warned, though, this kind of thing is never going to be a simple task, and you'll need to follow instructions/examples carefully!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #3
    Join Date
    Oct 2014
    Posts
    268
    Provided Answers: 6
    Thank you very much.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •