Some Built in function stop working

[AlTamres]

In existing database that was working now some of the built in function
stoped working and i get an undefined function error.
in a new test database they work.
the functions not working are;
date()
Left(expression,number)
Rightexpression,number)
When i call the db from different computers the same thing happens

Help
Al

 

[J. Goddard]

I think one of the references is missing in the database that does not
work. To see the references, open any code module, and click Tools -
References. Compare the list of checked references in the database that
does work, with the one that does not work to see which one is missing.

John

 

[fredg]

In existing database that was working now some of the built in function
stoped working and i get an undefined function error.
in a new test database they work.
the functions not working are;
date()
Left(expression,number)
Rightexpression,number)
When i call the db from different computers the same thing happens

Help
Al

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