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 gkittelson 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
Jul 27, 2003
24
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()
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top