enter current date automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

h
i have created a table in access which requires the current date to be automatically entered when a new record is created
can anybody help please? anything will be appreciated, and asap, as this is for a college project due in in 3 days! thanQ :-)
 
nikki169 said:
hi
i have created a table in access which requires the current date to be
Click to expand...
automatically entered when a new record is created.
can anybody help please? anything will be appreciated, and asap, as this
Click to expand...
is for a college project due in in 3 days! thanQ :-)

Just set the field's DefaultValue property to:

=Date()

That's it! You don't need to even include the field in the form or query
because it will be automatically generated. If you doo put it in the form,
lock the text box so no one can change it.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top