How to Add history to MS Access Form

Minnahil 0 Reputation points
2023-01-19T18:54:28.6066667+00:00

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!

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
726 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Ken Sheridan 2,346 Reputation points
    2023-01-20T22:55:08.96+00:00

    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.

    No comments

  2. Ken Sheridan 2,346 Reputation points
    2023-01-20T22:55:54.3266667+00:00

    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.

    No comments