Microsoft Access Data Base (Auto Date/Time Stamp)

  • Thread starter Thread starter bella.sandi
  • Start date Start date
B

bella.sandi

Hi,

I am working on an Access Data Base and need to incorporate an
auto date/time stamp but do not know how. I did locate the format
function that allows for that type of data to be formatted correctly
but do not know how to enter the formula for this; can you help?

Thanks,
Sandi
 
To record when a new record was created, just add a Date/Time field to your
table, and set its Default Value property (in the lower pane of table
design) to:
=Now()

If you want to also record the last date/time when the record was updated,
you will need to use some code in the BeforeUpdate event procedure of the
form where the updates take place.
 
Back
Top