Date and time

[Yasas de Silva]

How do I set up an automatic date and time field in Access which updates upon
changes to the record?

 

[Douglas J. Steele]

You can't. The only way you can get that capability is to put logic into the
form's BeforeUpdate event to change the date/time field.

 

[John Vinson]

On Sun, 6 Feb 2005 17:23:02 -0800, "Yasas de Silva" <Yasas de

How do I set up an automatic date and time field in Access which updates upon
changes to the record?

You'll need to do all changes to the data using a Form. Table
datasheets have no usable events.

Given this, just add a date/time field to the table, let's call it
ChangeTimestamp, and use VBA code in the Form's BeforeUpdate event:

Private Sub Form_BeforeUpdate(Cancel as Integer)
<any record validation code here>
Me!ChangeTimestamp = Now
End Sub

John W. Vinson[MVP]

 

[John Vinson]

Isn't the assumption that all changes to the data *will* be done 'using
a Form' wishful thinking? The front end shouldn't be used in place of
database constraints. How about a CHECK constraint to ensure the date
amended is always current? e.g.

That would be nice if Access supported CHECK constraints, Jamie.

Sorry, we're not using SQL/Server here. This is a different program
with different syntax. Triggers would be nice too.

John W. Vinson[MVP]