R
rocket
I want to set a date stamp for the date a record is created without the
field being changed everytime the record is accessed, how do I do this?
J
field being changed everytime the record is accessed, how do I do this?
J
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Steve Schapel
Rocket,
Set the Default Value property of the field in the design view of the
table to Date()
- Steve Schapel, Microsoft Access MVP
Set the Default Value property of the field in the design view of the
table to Date()
- Steve Schapel, Microsoft Access MVP
A
Allen Browne
1. Open the table in design view.
2. Add a Date/Time field to store the record creation date.
3. In the lower pane of table design, set the Default Value property to:
=Date()
Alternatively, if you want to store the time as wall as the date, use:
=Now()
2. Add a Date/Time field to store the record creation date.
3. In the lower pane of table design, set the Default Value property to:
=Date()
Alternatively, if you want to store the time as wall as the date, use:
=Now()
R
rocket
Thank You Steve & Allen