ACCESS says Date() function not defined

[JJ Smokes]

Please help!

I'm new with Access, but not new in general DB design. I have a query that uses the "Date()" function and has always worked previously. Randomly starting today, when I run the query, Access errors out and says: "Undefined function 'Date' in expression."

I was confused about why it would not recognize the built in "date" function, so I tried the Date() function on its own, and Access will not recognize it. It appears to no longer recognize Date() as a valid function. I have no idea where to go from here - has anyone had this problem with a built-in function losing its definition or know how to fix it?

Any help would be greatly appreciated!

 

[pbaldy]

Typically a reference problem:

http://www.mdbmakers.com/forums/showthread.php?t=2757

http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

 

[JJ Smokes]

Typically a reference problem:

http://www.mdbmakers.com/forums/showthread.php?t=2757

http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

That was exactly the problem... all is working again. Thank you so much!

 

[pbaldy]

No problem; welcome to the site by the way.

 

[JJ Smokes]

No problem; welcome to the site by the way.

Thanks! I've just started up a large data analysis project for my job using Access 2007, and since I've been using Access for about... 3 weeks now... you guys can probably count on me being in here bothering everyone for a bit! All the DB work I've done has been in the MySQL/PHP genre, so opening up Access for the first time is a change to say the least...

I'm glad sites like this exist: sometimes it is difficult to track down an answer in a book or in tutorials, because you don't know how to ask it - but having people with lots of experience around who are willing to help out is a lifesaver!

 

[odin1701]

mySQL and Microsoft SQL commands are very similar - if you work with that a lot, and you go to design queries in access, you can switch to SQL view and type out the statements manually if you want. You may be more comfortable with that.

But if you understand mySQL well, Micorosft's SQL should be cake for you, and you should also understand tables and such already pretty well.

VBA code is where things will get different than your mySQL/PHP.