Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Undefined function error message.

Status
Not open for further replies.

dpedley

Technical User
Apr 18, 2007
28
US
I have a database I have been developing in a folder on my D: drive named "Access Database Workarea" with a subfolder named "XXX Project" and other Subfolders beneath. Some of my modules have been hard coded to specific folders. Now I'm trying to test moving this database out into the environment where everyone will have a "XXX Project" folder. But when I moved the "XXX Project" folder to the root of D: and tried running the database I keep getting error messages that say things like "UCase" and "Mid" and "Left" were undefined functions. Why? and What do I have to do to correct it?

On a side note I don't understand. These are simple base MSAccess functions, why would they be undefined?
 
Sup,

Have you tried compacting and repair and/or recompiling?

Some weird errors have a funny way of getting corrected by these.

"If it's stupid but works, it isn't stupid."
-Murphy's Military Laws
 
Sometimes library references get corrupted in a copy. Go to a code module, click on Tools|References. If there are any that say "Missing", uncheck the box for that reference and try & compile again (if acent's advice doesn't work).
Good luck!

Silence is golden.
Duct tape is silver.
 
Yes, it is a missing reference to VBA as genomon stated.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top