Adding a Timestamp: Tracking When a Record Was Last Updated in Microsoft Access

In this Microsoft Access Tutorial, I will show you how to track when a particular record was last updated using one line of VBA code.

LEARN MORE:

RECOMMENDED COURSES:

LINKS:

BECOME A MEMBER:

ADDITIONAL RESOURCES:

KEYWORDS
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, Store the date and time when a record is modified, Form BeforeUpdate, How do you timestamp in Access, Detect time of last change on a Microsoft Access database, Time Stamping Records in Access, microsoft access audit trail, ms access history log, ms access timestamp, access log activity, track changes in access, after update, before update, afterupdate

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[zachrhoden]

These videos have been immensely helpful, I was asked to learn Access and then build a database for my company. It was daunting as first, but your videos made each lesson easy to digest and follow along. We are rolling it out later this week, so I just wanted to say a thank you for this treasure trove of helpful information. I wouldn't of gotten this far without it!

[akokohjoel]

Mr Rost you are the master of VBA made easy, I like your choice of word " One line of VBA code"

[SceneoftheCrymes]

Your Videos are a huge help. Thank you!

[donaldshroyer]

Can you refresh the record in the event to display the change to Last Updated?

[FlyHigh]

Thank you for the videos, they've been of great help.
You're doing this automation at form level. Is there a way to do it at table level?

[SonPham-wmfv]

My form have subforms, so when I edit the subforms it does not update the "Last update" field on the main form. Any suggestion? Thank you. By the way, your videos are very great.

[martyn]

Is there any reason why this event is not working on my database ? -thanks

[BudiartoAriansyah]

How make a formula for fractions of money...? For example: 2, 486, 000 if I want to divide it into fractions of 100, 000, 50, 000, 20, 000, 10, 000, 5, 000, 2, 000, 1, 000, each fraction can automatically result in how many sheets. Thanks Sir