Auto Date and time insert

A

Andrew

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
 
R

Rick B

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
 
Top