Why don't MS Access 2003 string functions work?

[Guest]

Have used string functions like Left, Right, Ucase, etc. in Access 2000,
Access 2002 (Win 2000 OS) apps with no trouble. Running the same apps in
Access 2003 (Win XP, SP2) results in error messages, even though the
functions are allowed in the "build" part of the query setup for calculated
fields. I'm mystified. Any thoughts?

 

[Rick Brandt]

Have used string functions like Left, Right, Ucase, etc. in Access 2000,
Access 2002 (Win 2000 OS) apps with no trouble. Running the same apps in
Access 2003 (Win XP, SP2) results in error messages, even though the
functions are allowed in the "build" part of the query setup for calculated
fields. I'm mystified. Any thoughts?

You have missing references which is an issue any time you move to
different PCs. The fact that your problem PC has Access 2003 or a
differnt OS is not relevant.

Open the VBE window and then go to Tools - References. You will likely
see one or more checked references with the word "MISSING" at the front
of them. These either need to be removed or repaired.