Undefined function Left in expression

[Andy]

After upgrading to Windows 2000 from 98, I got the
following error message:

"Undefined function 'Left' in expression" when trying to
run a query and a form that relies on that expression.
This query and form work fine on all the other systems on
the network, except for on the one I upgraded.

Suggestions?
..

 

[Timothy C. Doherty]

You're probably missing a reference. Open your VBA editor, click
Tools|References, and look for any "MISSING" references...

 

[Arvin Meyer]

You have a missing reference. Open any code window (Ctrl+G) and on the
menubar choose Tools ... References and uncheck or find any marked as
missing. Hint: Windows 98 uses the C:\Windows\System\ folder for many dlls
while Windows 2000 uses C:\WINNT\System32\ as the default folder.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access