S
Sokan33
How can I time stamp when entry is made for the first time? With regards to
all.
all.
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.
A
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
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
S
Sokan33
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!
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!
J
Jeff Conrad
in message:
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)
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)
A
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
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