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

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
 
A

Allen Browne

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).

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.
 
F

Frank Martin

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.



Thanks, this worked.
 

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

Top