Date ()

[wiltshire]

Hi,

I have recently upgraded my PC from Access 97 to Access XP Developer (I know, a bit of a jump !!) and I am having some problems with the converted databases. Queries that use the DATE() function are now bringing up the error message 'Undefined function DATE in expression'.

Can anyone tell me if Date() is actually supported in Access XP. I've tried the Help menu, but I'm sure as many of you have found, it's like looking for something in a Haynes car manual !!

Thanks

 

[Rich]

You have a missing reference, search here for specific answers on the subject, the same question was posted just a few days ago

 

[wiltshire]

sorry to be a complete muppet, but having as much luck finding the post on this site as with the help file on my PC, can you just tell me..........oh go on !!

 

[neileg]

Click the Search Button at the top right of the screen. In the keyword box type Missing reference Just about any of the returned postings will answer your question.

 

[pdx_man]

http://www.access-programmers.co.uk...=&threadid=39893&highlight=missing+references

 

[wiltshire]

Hi Again,

Thanks for the info. but still no luck. I used Alt + F11 to get to the visual basic module then tools, references to list them. There were none marked as missing, just a list that were checked. How do you know if they're missing?

Thanks

 

[pdx_man]

Are you referencing another Office object library? Say, Excel, which on the machine you developed was 8.0 and now on the new machine is 9.0?

 

[Pat Hartman]

Make sure you have the Microsoft DAO 3.6 library selected.

 

[krisleech]

This is odd because i have had the oppasite problem (to the orignal post) i have been developing in Access 2002/XP and when exporting as Access 2000 and opening the database on a different PC with Access 2000 installed i get an error for date(), which i have temperory replaced with now() which works.
Now if Access 97 has Date() im sure Access 2000 has!

Also i had problems with Left() and Format()

Kris.

 

[Rich]

krisleech, you have the same Missing Reference problem, read here for more info
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html