Default Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field of type Date/Time and I want the form when it opens to display
the current date so at the DefaultValue of this field, I entered the Date()
expression. It was working fine all along but now after adding two additional
fields to the table, I get this error everytime I tried to save the table:

Unknow function 'Date' in validation expression or default value on
'tblTable.dteDate'.

What is wrong? I'm using Access 2003 now but table was created with Access
2002. Thanks.
ck
 
Hi.
Unknow function 'Date' in validation expression or default value on
'tblTable.dteDate'.

What is wrong? I'm using Access 2003 now but table was created with Access
2002.
Click to expand...

Most likely this is due to a missing Reference. This often occurs when the
database is developed on a computer that is configured differently than the
computers where the database is deployed.

Open the VB Editor and open the References dialog window by selecting the
Tools menu -> References. Remove any "MISSING:" References and then add the
same named References with the correct paths on the Access 2003 computer.
Close the References dialog window and attempt to recompile by selecting the
Debug menu -> Compile <DatabaseName>. Fix any errors, then attempt to
recompile the VBA code repeatedly until the code compiles without errors.
Once it compiles without errors, your References Collection should be
complete.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that the first and
best answers are often given to those who have a history of rewarding the
contributors who have taken the time to answer questions correctly.
 
Back
Top