Undefined "function" error

[heatherci]

Hi, I have an Access 2003 database on our server and it has been working fine until two days ago. Certain queries are running into various Undefined "function" errors. The functions so far have included the date() and Mid function. What is now causing this and can it be corrected?

 

[TheAceMan1]

How are ya heatherci . . .

Post the SQL of one of the problem queries! . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[Ed2020]

I've experienced similar problems, albeit with the Environ() functions. They appeared after updates were applied to the Office installation. You could confirm the source of your problem (database or Access installation) by creating a new database and containing a query using the same problem functions.

One (fairly unsatisfactory) solution I found was to have a public function in aVBA module to return the value you're interested in and reference that in your query instead:

Public Function MyDate() as Date
   MyDate=Date()
End Function

Of course this isn't much good if you have problems with lots of different functions...

Ed Metcalfe.

Please do not feed the trolls.....

 

[JoeAtWork]

Most likely reason is one or more references have been broken. The error message has nothing to do with what is actually wrong (why Microsoft has never fixed this problem, which has been around at least since Access2000, is something I'm keen to know).

Open up your References dialog box (on the Tools menu when you are in a VBA screen) and look for references that are marked MISSING. Sometimes the fix is to uncheck those references, close the dialog, reopen the dialog and check those references again, and finally close again.

Sometimes it means you need to install something on the client computers.

 

[TheAceMan1]

So what happen to [blue]heatherci?[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886