 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / September 2006automatically recording date
In my form, I want to be able to have the date automatically entered for a record, after a change or modification is made to an existing record. Add a LastModified Date/Time field to your table. In your form's BeforeUpdate event, add code to set that field to Now().  SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > In my form, I want to be able to have the date automatically entered for a > record, after a change or modification is made to an existing record. Use the form's Current event: Me.txtMyDateField = Date() > In my form, I want to be able to have the date automatically entered for a > record, after a change or modification is made to an existing record. I don't think that's really what you want. That'll update the date every time you access it, even if no change was made. SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) > Use the form's Current event: > Me.txtMyDateField = Date() > >> In my form, I want to be able to have the date automatically entered for >> a >> record, after a change or modification is made to an existing record. Try the OnDirty Event That says a change was made somewhere. Ron I still think BeforeUpdate is a more appropriate event. SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) > Try the OnDirty Event > > That says a change was made somewhere. > > Ron |
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.