Backup a Record Before it's Edited

In today's lesson I'm going to show you how to backup a record in your database before someone makes changes to it. This way you have a complete history of all of the edits, in addition to a date/time stamp of when it was edited.

Topics Covered

• Making a Backup Table
• Change AutoNumber to Long Int
• DateUpdated Field
• NOW() Function
• Append Query Warning Messages
• OnDirty Event
• DoCmd.SetWarnings
• Confirm Action Queries

Members

There is no Extended Cut for this video.

Links

Input Masks: https://599cd.com/InputMask
Access Beginner 3: https://599cd.com/acb3

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.