Time Stamp

A

Adam

How can I automatically populate the current date into a field for a new
record? Will this automation apply a new date to all records?
 
D

Darrell Childress

Adam said:
How can I automatically populate the current date into a field for a new
record? Will this automation apply a new date to all records?
Click to expand...

Set the default value to be Date(). This is done in the table design
view. You can, obviously, set the format in the field to show only date,
or date and time if you need to know the time of day the record was added.
 

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

Time Stamp 2
Inserting Date/Time stamps 6
date stamp 1
Access MS-ACCESS 2010 - Date Stamps 13
Now Date Time Field in Form 6
Date stamp a notes field 18
Programatically Populate a Field? 8
Add one year in second combobox in vba 0

Top