 | |
Date field that automatically updates record with date last modified (i.e. current date you're editing the field)
comp.database.ms-access comp.database.ms-access
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Date field that automatically updates record with date last modified (i.e. current date you're editing the field) -
09-15-2003
, 04:37 PM
#2
| |||
| |||
|
|
Honestly I can't believe I'm asking this question, since I've worked on Access for years, but I've been away from it for a bit and for some reason I'm feeling rusty. I need to create a date field that automatically updates with the current date and time each time a record is modified/updated. Do any of you know how to do that? Thanks |
macro/code that will update the date/time field to the current date/time.
eg.
Private Sub frmMyForm_AfterUpdate()
Me![RecordTimeStamp] = Now()
End Sub
Hope that helps.
--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/reponse
#3
| |||
| |||
|
|
"sjboyd81" <stacey.boyd (AT) hillandknowlton (DOT) com> wrote in message news:bdaeaa.0309151337.6265fd86 (AT) posting (DOT) google.com... Honestly I can't believe I'm asking this question, since I've worked on Access for years, but I've been away from it for a bit and for some reason I'm feeling rusty. I need to create a date field that automatically updates with the current date and time each time a record is modified/updated. Do any of you know how to do that? Thanks Create a form bound to your recordset. On the AfterUpdate event create a macro/code that will update the date/time field to the current date/time. eg. Private Sub frmMyForm_AfterUpdate() Me![RecordTimeStamp] = Now() End Sub Hope that helps. |
Just a quick question. Wouldn't you put that code:
Me![NameOfFieldHere].value = Now()
in the before update property of the form?
Just a question.
Ray
#4
| |||
| |||
|
|
"Bradley" <bradley (AT) REMOVETHIScomcen (DOT) com.au> wrote "sjboyd81" <stacey.boyd (AT) hillandknowlton (DOT) com> wrote in message news:bdaeaa.0309151337.6265fd86 (AT) posting (DOT) google.com... Honestly I can't believe I'm asking this question, since I've worked on Access for years, but I've been away from it for a bit and for some reason I'm feeling rusty. I need to create a date field that automatically updates with the current date and time each time a record is modified/updated. Do any of you know how to do that? Thanks Create a form bound to your recordset. On the AfterUpdate event create a macro/code that will update the date/time field to the current date/time. eg. Private Sub frmMyForm_AfterUpdate() Me![RecordTimeStamp] = Now() End Sub Hope that helps. Hello, Just a quick question. Wouldn't you put that code: Me![NameOfFieldHere].value = Now() in the before update property of the form? Just a question. Ray |
One has to watch triggering another Update...
--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/reponse
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.