Solved

How do I capture and record 'last modified information?'

Posted on 2008-10-23
2
349 Views
Last Modified: 2013-11-29
On our client database, we'd like to add a column that is automatically populated with date & time when that record changed. How can we do that? I have already created a column and called it 'Last Event Date.'
0
Comment
Question by:King_of_Salem
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 125 total points
ID: 22785646
Use the beforeupdate event procedure for the form used to modify the data.
Add one line to the procedure.

me.[last Event Date] = Now()
0
 

Author Closing Comment

by:King_of_Salem
ID: 31509179
Thanks Peter57r. It worked!
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question