datestamp

[-00MichaelJordan]

How can I make a datestamp on the records in a table when they are modified
or created? I am running Access 97? Thanks.

 

[Guest]

Hi

Create a new field in your table called DateStamp.

Insert this new field into your form.

Use the forms event OnCurrent

Me.DateStampt = Now()

Note this will alter the date stampt every time the form is activated. if
you want to keep a record of "each" time the form is used you will need
another table linked to your main table by the primary field used in the form.

 

[RoyVidar]

Hi

Create a new field in your table called DateStamp.

Insert this new field into your form.

Use the forms event OnCurrent

Me.DateStampt = Now()

Note this will alter the date stampt every time the form is
activated. if you want to keep a record of "each" time the form is
used you will need another table linked to your main table by the
primary field used in the form.

Would it perhaps be better to use the before update event, in stead of
the on current event?

With the on current, it will be updated any time you browse the record,
while with the before update, it will be updatet only when created or
edited.

 

[Guest]

Yep - you're most likely right the before update event would be a better idea.

when they are modified or created

was what was asked. I should read the post more carefully.

It my age - eyes are going V quick. LoL