Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Location
    San Antonio, TX
    Posts
    69

    Unanswered: Tracking changes

    I'm trying to develop some sort of tracking system within a database I've created. It's currently tracking user logins as well as when new records are added. What I'm not sure to proceed on is how to track changes or edits to records. Can anyone give me some ideas how to figure out if a record has been edited?


    Many thanks in advance.

  2. #2
    Join Date
    Apr 2002
    Posts
    139
    To all readers:
    New to this forum, hope that I may contribute a little.

    To Punkerboy,

    Seems that you are familiar with VBA.
    Have a look at the keyword Dirty.
    A record gets 'dirty' as soon as it is edited, but not saved yet.

    Create an event that checks for this 'dirty' state, and respond to it as you like.

    Marion

  3. #3
    Join Date
    Feb 2002
    Location
    San Antonio, TX
    Posts
    69
    Thanks Marion. I'll check it out.

Posting Permissions

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