UNDEFINED FUNCTION ERROR

[SupperDuck]

Dear all,

I had no problems with my access querries till i today. When i came to
office and started daily reportw, querries having functions such as year,
month, nz... become to give errors.. "undefined function nz.."

We have no admin rights on PCs and i did not make any changes on my
computer.. But, yesterday there had been an update in systems (but could not
remember what it was...) and i guess there must be a relation.

I am using English Windows, English Office but local settings for language
is Turkish..

Regards,

 

[Tom Wickerath]

Hi SupperDuck,

This sounds like a MISSING reference problem to me. Have you checked for
this possibility? Here are two excellent articles on this topic:

Solving Problems with Library References (Allen Browne)
http://allenbrowne.com/ser-38.html

Access Reference Problems (Doug Steele)
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________