Auto Date and time insert

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

Guest

How can i create my database to auotmatically enter the date and time when a
new line is added to my database? These fields will be the primary key as no
two lines shall be created at the same time!!
many thanks
 
In the field on the form you will use for data entry put the following in
the "default" for that field...

= Now()


You could also use some variations of date() time() now() the current user
id, etc.

I would lock this field so my users could not modify it.

Rick B
 
You must log in or register to reply here.

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

Auto Date Input 4
Data Entry Form and Auto Number ID 2
Datepicker issue after changing Windows' short date time format 5
Access Access 2003 Carriage Return Insertion 0
Same record/Primary key in multiple tables 0
Data Copying 1
Date and Time 3
Extracting only the Date part of a Date/Time field 5

Back
Top