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
 

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

Excel Vba to change displayed year automatically. 14
Date search query 0
Excel Excel due and overdue date colours 2
Special Date Input Settings 2
I want access to fill a field with the current date 4
Access Automatically Send a notification email once a record is added 0
Keep last entered date on form 5
current date enter automatically when new data entered on a record 4

Back
Top