Error "undefined function 'left' in expression"

[M.S.Huizenga]

Hi everybody,

Has there anyone got a solution to my problem:
- recently got Windows Vista
- since then, queries with the string function left (e.g. left("member",2)
equals "me") don't work

Further details:
- Windows Vista Home Premium
- Regional settings: Dutch
- Office (Access) version 2003 SP2

Any help will be greatly appreciated. Thkx. M.S.Huizenga

 

[Guest]

Reference problem. Go to the following web page for information on checking
references:

http://www.mvps.org/access/bugs/bugs0001.htm

 

[fredg]

Hi everybody,

Has there anyone got a solution to my problem:
- recently got Windows Vista
- since then, queries with the string function left (e.g. left("member",2)
equals "me") don't work

Further details:
- Windows Vista Home Premium
- Regional settings: Dutch
- Office (Access) version 2003 SP2

Any help will be greatly appreciated. Thkx. M.S.Huizenga

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