In Access how do i store historical dates of record modification

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
Back
Top