I have a database with multiple users. When the users make changes to the records; i.e., update fields on the records I would like to append simple notes in a memo field which would indicate changes made including user and date of change. Currently I only use a message/response box to insure that user wants to overwrite existing data. I think I can test the various editable fields as being dirty but not sure how to retrieve the original value to be used in the note being created.
My current approach is to use temp (original values) variables to compare with new values. At typical note would be:
Due date changed from 9/20/13 to 10/15/13 by John on 9/12/13
Question are the pre-dirty values available before updating the records?
Thanks for any help. (Using Access 2010 on Windows 7)
Rod
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar