Undefined Function Message

[Anthony Viscomi]

Whenever I try to use MID, RIGHT or LEFT from within my query I receive
"Undefined function * in expression. Here is an example of what I have:
Expr1: Left([WKRSMN],1)

any thoughts?

 

[Rick Brandt]

Whenever I try to use MID, RIGHT or LEFT from within my query I
receive "Undefined function * in expression. Here is an example of
what I have: Expr1: Left([WKRSMN],1)

any thoughts?

See link below...
http://www.mvps.org/access/bugs/bugs0001.htm

While it talks about this happening after an upgrade from Access 95 to
Access 97 the problem described can in fact happen for a lot of reasons in
any version of Access.

 

[Guest]

check the reference files in your DB and see if anything missing.
that will cause access not to recognise functions

To open the refernce files, open the any code section, go to tools, reference.

 

[fredg]

Whenever I try to use MID, RIGHT or LEFT from within my query I receive
"Undefined function * in expression. Here is an example of what I have:
Expr1: Left([WKRSMN],1)

any thoughts?

That PC has a missing reference.
Open any module in Design view (or click Ctrl + G).
On the Tools menu, click References.
Click to clear the check box for the type library or object library
marked as "Missing:."

An alternative to removing the reference is to restore the referenced
file to the path specified in the References dialog box. If the
referenced file is in a new location, clear the "Missing:" reference
and create a new reference to the file in its new folder.

See Microsoft KnowledgeBase articles:
283115 'ACC2002: References That You Must Set When You Work with
Microsoft Access'
Or for Access 97:
175484 'References to Set When Working With Microsoft Access' for
the correct ones needed,
and
160870 'VBA Functions Break in Database with Missing References' for
how to reset a missing one.

For even more information, see
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html