Function issue

  • Thread starter Thread starter Sarah at DaVita
  • Start date Start date
S

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?
 
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 ?
 
I can use the function in other databases. Seems it is just this one.
Click to expand...

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.
 
Back
Top