Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Auto Time and Date

Status
Not open for further replies.

Clegg25

MIS
Joined
Jul 27, 2003
Messages
24
Location
US
Hi,
I am trying to create a table that someone would enter a log entry into. But, I want it to keep an auto time and date on the post, after the person posts the comment.
e.g.
Field 1 would be the text entry the person would make
Field 2 would be a Yes/No checkbox
Field 3 and or 4 would be my autotime/date, but i cant figure that part out.
thanks
 
You can use the function
Code:
Now()
which returns the present date and time.
 
To build on nicsin's reply, use a single date/time field in your table and set the Default Value property to:

=Now()
 
it works great. thank you very much
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top