Microsoft Access Data Base (Auto Date/Time Stamp)

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
 
A

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automation of scanned file storage based on content 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Autofill Date in Word 15.33 for Mac 0
Date Time Stamp formatting 5
how do i set an auto date & time stamp for notes in contacts? 2
Copy previous record into form field 0
Forcing a date entry format of dd/mm/yyyy 1
Problem with MS Word paragraph and character styles: format getting messed up 2

Top