UCase does not work in a Query

[garybonk]

A few years ago, I wrote an application in Access 2000 that worked fine. Last year I upgraded to Access 2003. Everything works the same, but the UCase, Left and Right text functions give error messages when used in queries. Anyone have a way to fix this?:

 

[pdx_man]

Check the References. Lots of posts here regarding this. Do a search on References

 

[garybonk]

Its fixed

Many thanks to PDX_MAN.

Problem: Microsoft Office Access 2003 error message when running a query:

'Undefined function "UCase$" in expression'

Solution: Went to VB/Tools/References. Got MS error message:

"... missing or broken reference to circ3.ocx ...."

I unchecked the Reference line for that file and hit OK.

When I went back to the Access application, it worked fine.

Thanks again, PDX_MAN, for the direction.

Gary