auto add last modified

P

Porthale

Hi folks

Really could use some help here, I have an access 2000 database, I need
it to automatically add a date to the "lastupdate" field when a record
is modified.

Any help would be greatly appriciated.

I can email the database if needed.

Cheers
Darren
 
N

Naresh Nichani MVP

Hi:

If updates are done via a form you could trap the Form_BeforeUpdate event
and write code like this --

Me.DateLastUpdate = VBA.Now()


This assumes you have a Date/Time field called DateLastUpdate in the table
bound to form.

Regards,

Naresh Nichani
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help modifying code 0
Automatically Update "lastupdate" field 1
How do I clear a form? 0
Copy previous record into form field 0
Synchronization problems while moving folders to new email 1
MS Outlook inbox to MS Accsess Database 0
Show the date of the last time the query was run 8
=Date() not found 5

Top