 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / December 2005In Access how do i store historical dates of record modification
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. >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. 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  SignatureMarsh MVP [MS Access] Thank you very much Marshall. I really appreciate it. > >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 [quoted text clipped - 6 lines] > to set the value of the field: > Me.ModifiedDate = Date |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.