?
Solved

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

Posted on 2008-10-23
2
Medium Priority
?
373 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 500 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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

589 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