Left Function

  • Thread starter Thread starter Louise
  • Start date Start date
L

Louise

I just finished upgrading my pc to XP and now the Left,
Mid, and right functions do not work in Access 97. The
queries using these functions run, but return #error for
the result. In some queries that use these functions I
am getting the message "This expression is typed
incorrectly, or it is too complex to be evaluated...."
These functions all worked prior to the upgrade. I did
go to the Modules and selected Tools and References and
checkmarked Microsoft ActiveX Data Objects 2.7 Libraries,
but that did not fix this problem. Can anyone help?
Thanks!
 
Louise,
It is a reference problem.
Are any marked MISSING?
Are the correct ones checked?
See the below KnowledgeBase article for the correct ones.

Open any module in Design view.
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'
and ..
160870 'VBA Functions Break in Database with Missing References' for how to
reset a missing one.
 
Back
Top