In Access how do i store historical dates of record modification

G

Guest

I am working on Access 2003, and I am trying to figure out how I can store
historical dates of when a given record was edited/modified. Any help you
provided would be greatly appreciated. Thanks.
 
M

Marshall Barton

NewUserToAccess said:
I am working on Access 2003, and I am trying to figure out how I can store
historical dates of when a given record was edited/modified. Any help you
provided would be greatly appreciated. Thanks.
Click to expand...


A CreatedDate field can be set automatically by setting the
field's DafaultValue property to =Date() or =Now()

A ModifiedDate field can use the form's BeforeUpdate event
to set the value of the field:
Me.ModifiedDate = Date
 

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

History of who modified a given record and and the dates he/she mo 1
record count from system 3
Excel Macro for deleting Rows containing dates greater than "today" 0
Access Automatically Send a notification email once a record is added 0
Interested in thoughts on keeping the integrity of historical data 17
Matching Data between 2 Tabs on Same Workbook - then calculating 2
Storing images in Access 9
Excel Average dates help 0

Top