| | |
|
|
|
auto insert date/time |
|---|
| message from Rick B on 11 May 2004 |
One which will show the present date and time whenever a record is modified
and also add this date to the record itself
One which will insert the present date and time whenever a record is created
and also add this date to the record itself
-rick
|
| Allen Browne replied to Rick B on 12 May 2004 |
=Date()
The modified date can only be maintained if the data is changed through a
form. Use the BeforeUpdate event procedure of the form:
Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.[NameOfYourDateFieldHere] = Date()
End Sub
If you want the time as well as the date, use Now() instead of Date().
|
|
Archived message: auto insert date/time (Microsoft Access Database)
