#Name! as a control and an unavailiable function 1

[FunkyMonkey]

This is strange little thang has been bugging me...

Having built an application in Access 97 for distribution to several users (running the program on both 95 and NT workstaion), i find that some problems are occurring on users machines while not appearing on mine (Access 97 on NT w'station).

To cut to the chase, the problem seems to stem from the fact that Access on the users machine cannot recognise any date function in an expression in a query, form or report.
When I try to run an invoice query based on dates, a message box appears saying "function isnt available in expressions in query expression 'Format([datDateInvoiced],"m&quot', and the query cannot run. Even something as simple as "Date()" is not recognised!

Of course, the help option accessible through the message box is as useful as a chocolate teapot.

Any ideas what the issue is here?

Thanks to the good folks who may be able to assist...

 

[RobertT687]

Sounds like a broken reference to me. Since you have two different operating systems you probably have different versions of other MicroSoft products (ie Office, Outlook etc.).

On a machine that fails, open any module in design mode or open a blank new one. On the main menu bar click Tools > References. The problematic reference will have a check mark in front followed by the word MISSING: and the reference name. You need to determine the equivalent reference on that particular machine.

I see this problem occasionally when users have different releases of Microsoft Office.