Date Stamp

[Mark Napier]

Hi,
For verification that my clerical staff are inputting our client data on the
date the client first came, I need an automated date stamp, that will return
the date the data was input.

 

[jmonty]

If you are saving this in a table field:
Go into table design and select the field. (It must be set to type:=
Date/Time)
Enter Now() or Date() in the Default Value.

If you are using a data entry form:
Open it in design mode. Right click on the field and select properties.
On the Data tab..
Enter Now() or Date() in the Default Value.

Now() will give you the full date (12/25/2006 12:00:01 AM)
Date() will give you just the date (12/25/2006)
Time() will give you just the time (12:00:01 AM)

If your table field name is "Date" or "Time"
Be sure to use [ ] brackets around the field names in queries and vba code
when referring to fields that are using these reserved words as the column
header so that Access can distinguish between your table field name and the
built-in function.

jmonty

 

[Craig Hornish]

If your table field name is "Date" or "Time"

Be sure to use [ ] brackets around the field names in queries and vba code
when referring to fields that are using these reserved words as the column
header so that Access can distinguish between your table field name and
the
built-in function.

Better yet - Change it to DateStamp or TimeStamp - for clarity (BirthDate,
HireDate etc.) and the issue about reserved words.

--
Craig Hornish

Visit weekly Access conferences
Tuesday, 11:00am-12:30pm (Eastern US)
Thursday, 3:30pm- 5:00pm (Eastern US)

http://community.compuserve.com/n/pfx/forum.aspx?webtag=ws-msdevapps

"Think outside the box, because anything is possible."
"How long it will take or whether it requires divine intervention is another
issue"

If you are saving this in a table field:
Go into table design and select the field. (It must be set to type:=
Date/Time)
Enter Now() or Date() in the Default Value.

If you are using a data entry form:
Open it in design mode. Right click on the field and select properties.
On the Data tab..
Enter Now() or Date() in the Default Value.

Now() will give you the full date (12/25/2006 12:00:01 AM)
Date() will give you just the date (12/25/2006)
Time() will give you just the time (12:00:01 AM)

If your table field name is "Date" or "Time"
Be sure to use [ ] brackets around the field names in queries and vba code
when referring to fields that are using these reserved words as the column
header so that Access can distinguish between your table field name and
the
built-in function.

jmonty

Hi,
For verification that my clerical staff are inputting our client data on
the
date the client first came, I need an automated date stamp, that will
return
the date the data was input.