How do I record the date of the first record entry.

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

Frank Martin

I have a small database and I want to record, in a table
field, the date at which a record is added (but not edited).

I want this to be permanent.

Should I make the "primary key" this date?

Please help, Frank
 
Frank Martin said:
I have a small database and I want to record, in a table field, the date
at which a record is added (but not edited).
Click to expand...

In table design view, add the field to record when the entry was made.

In the lower pane of table design, set the Default Value property of this
field to:
=Date()
if you just want the date. If you want the date and time, use:
=Now()

When you create a form to show the entries, don't provide a text box for
this field, so the user won't have a way to modify the date.
 
Allen Browne said:
In table design view, add the field to record when the
entry was made.

In the lower pane of table design, set the Default Value
property of this field to:
=Date()
if you just want the date. If you want the date and time,
use:
=Now()

When you create a form to show the entries, don't provide
a text box for this field, so the user won't have a way to
modify the date.
Click to expand...



Thanks, this worked.
 
Back
Top