May 14th, 2010, 07:55 AM
posted to microsoft.public.access.tablesdbdesign
|
|
|
How do I record the date of the first record entry.
"Allen Browne" wrote in message
...
"Frank Martin" wrote in message
...
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.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
Thanks, this worked.
|