Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557

    Unanswered: Does anyone track changes made?

    Does anyone track who changed the data and when? If so do you have a recomendation to me on how is the best way to track changes?


    Thanks,
    Jarvis
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Create a table for the changes with a date, username, and previous value for whatever table you need to track.

    I'm hoping you don't have to track much. If you only need to track information in one table, the above suggestion will do the trick. Multiple tables gets quite a bit more irritating.

  3. #3
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557

    Tracking multiple tables :-/

    I was trying to track the:

    User (when first put into database)
    Date Entered (when first put into database)

    and

    WhoChange (u/n that changed something in the record)
    ChangeDate (date that person changed that record)

    Currently I have code in all of my forms that as soon as one thing is changed it sets the ChangeDate and WhoChange to DateTime.Date and CurrentUser respectively.

    I was trying to simplify my code by creating a module so all I have to do is call a function that way it would save me alot of copy and paste for all of the like 20 forms I have.

    Anything to help would be much appreciated. I dont really need to track the old value... just what the new one is. I need it in a module public function so I can call on it from any form.

    Thanks so much,
    Jarvis
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

Posting Permissions

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