How to Add history to MS Access Form

Question

Hello,

I have a problem that i need a solution for i need to Add History to MS access Form so i can track when a field in the form has been updated (Timestamp like date and Time),Which Field was updated and What was the original content of the Field that was updated. I am in Fix with Code for this I would like you to write me a solution to this problem Thankyou!

Answer 1

You might like to take a look at ChangedRecordDemo.zip in my public databases folder at: 

https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169 

If you have trouble downloading a specific file, clicking on the 'Download' button at the top of the page while no files are selected should download a zip file of all files in the folder, from which you should then be able to unpack the relevant file. 

This little demo file illustrates a number of ways to time stamp or log changes to data. Including an option to insert rows into an audit tail table. 

The key thing about this demo is that it detects actual changes to data rather than merely updates.  A row in a table can be updated without the values of the data actually changing.

Answer 2

You might like to take a look at ChangedRecordDemo.zip in my public databases folder at: 

https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169 

If you have trouble downloading a specific file, clicking on the 'Download' button at the top of the page while no files are selected should download a zip file of all files in the folder, from which you should then be able to unpack the relevant file. 

This little demo file illustrates a number of ways to time stamp or log changes to data. Including an option to insert rows into an audit tail table. 

The key thing about this demo is that it detects actual changes to data rather than merely updates.  A row in a table can be updated without the values of the data actually changing.