Function issue

[Sarah at DaVita]

I am trying to use the Left function in a query - do it all the time. This
time i keep getting the error Undefined function <name> in expression. (Error
3085) even though I am using the builder and selecting it from the list of
available functions. Anyone seen this before?

 

[BruceM]

It could be a references problem:
http://allenbrowne.com/ser-38.html

 

[Wayne-I-M]

it may not be the left thats causeing the problem.
Can you post the sql

Also have you checked that none of the references are missing or damaged

Also - do all the other lefts that you have used still work ?

 

[Sarah at DaVita]

I can use the function in other databases. Seems it is just this one.

 

[John W. Vinson]

I can use the function in other databases. Seems it is just this one.

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.