Date() not being recognized

[JHeimall]

I am having difficulty with the Date() being recognized. When I run the report I get the #Name? error. Also, the
Now() works perfectly fine. I did not think there were any references that needed to be turned on to access this function.

 

[zatch]

Do you have a "=" in front of date()?

=date()


Zatch

 

[SgtJarrow]

And whoever told you Date() was not part of a reference set is wrong! Check your references.....20 to 1 that at least one of them has a MISSING: in front of it.... Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III, MCP, Network+, A+
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com

 

[JHeimall]

I have tried these options but they have not resolved the problem. I checked to see if the reference file was not checked but it was (Visual Basic for Applications, VBA332.dll). I also checked whether the file was corrupt but the same file is used in other database applications and works fine. I have tried setting the Control source of the textbox to =Date and =Date(). If anyone else has any other suggestions that would be great. Also, like I said before the Now() works fine and I believe it is in the same dll file.

 

[Maquis]

One more thing to check... What is the name of the textbox that is set to =Date()? Is the name "Date"? If so, you have a circular reference. Change the name to something else and it will work. Maq
<insert witty signature here>

 

[ApplePirate]

JHeimall

have you set the control source to '=Date()'
if so i think this may be incorrect, you should have set the default value to 'Date()', the control source is where you want the date stored...
im still new to this to so slap me if im wrong




I'd rather be a pirate than join the navy...

 

[JHeimall]

No, It is ok to set the Control Source to Date(), because it works fine when I set Control Source to Now(), and it works fine in other database applications when I set the Control Source to Date(). This is something specific to this access file that causes the problem. Thanks though for trying to help.

 

[Trainingjason]

In the part I have the date missing when migrating downwards from 2000 to 97. Check your references and if it still does not work copy the database into a new file

jason

 

[JHeimall]

Anyone else have any ideas?

 

[zatch]

When I get unexplainable errors like this I start by going into a piece of code and compiling all modules. This has worked for me in the past.

Zatch