Entry time stamp

[Guest]

How can I time stamp when entry is made for the first time? With regards to
all.

 

[Arvin Meyer [MVP]]

Add a field to the table with the Date/Time datatype and set its
DefaultValue to:

= Now()

Set the format to "General Date"

When a record is added, the field will update to the current timestamp
automatically because of its default value.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Arvin,
Thanks for your prompt response. I did as suggested but the field return
#Name?. Is there any property setting that need to be changed. Thanks!

 

[Jeff Conrad]

in message:

Thanks for your prompt response. I did as suggested but the field return
#Name?. Is there any property setting that need to be changed. Thanks!

Might have a References problem. See this link on my page for a description
of the problem and fixes:

http://home.bendbroadband.com/conradsystems/accessjunkie/references.html

(Watch out for any possible line wrapping on the link)

 

[Arvin Meyer [MVP]]

Open any code window (Use Ctrl+G to open a blank debug window if there is no
code) On the menu go to the Debug item and try to compile your database. It
will throw an error if the references aren't correct. Clear the error and go
to Tools ... References. At least 1 will be marked "MISSING". You may be
able to simply uncheck it, but more likely you'll need to read the file it's
supposed to be by selecting it. Then use the Browse button to go find that
file.

When you are done, compile again and the #Name error will go away.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access