undefined function UCase in expression

[Guest]

In an update query that used to work properly I now get the message
"undefined function UCase in expression". Thinkiing the built in functions
are corrupt or missing, I reinstalled Access but it did not help.
Will someone please tell me how to get the built in functions back? Or send
me the code for the function.
Marty

 

[Guest]

Hi Marty,

Most likely, you are experiencing a problem due to a MISSING reference. Here
are two excellent article on the topic:

Solving Problems with Library References (Allen Browne)
http://allenbrowne.com/ser-38.html

Access Reference Problems (Doug Steele)
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

['69 Camaro]

UCase( ) is a VBA function. It's likely that your database application is
missing a library Reference. Open the VB Editor and select the Tools
menu -> References... to open the References dialog window. You will
probably see one of the library names listed, preceded by the word "MISSING:
" to indicate that Access cannot find this file.

If you find that any of the References are missing, note the name of the
file and its location, then uncheck this Reference, then close the
"References" dialog window. Open the "References" dialog window again and
add the Reference from the list (or browse to it). When you are finished,
close the "References" dialog window and compile the code (Debug menu ->
Compile <DatabaseName>).

If you don't find any of the References marked as missing, then attempt to
compile the code first, then open the "References" dialog window to follow
the steps above. If that doesn't work, then add a new reference (any one,
just note which one so that you can remove it later), compile the code, and
then remove the extra reference that you just added. The "MISSING: "
reference should reveal itself by then.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Guest]

Thank you so much. I did an end run temporily by formatting the text box ">"
which I found in another posting. Now I'll try to fix it right.

 

[Guest]

Thank you Tom. I will check the sites out.

Hi Marty,

Most likely, you are experiencing a problem due to a MISSING reference. Here
are two excellent article on the topic:

Solving Problems with Library References (Allen Browne)
http://allenbrowne.com/ser-38.html

Access Reference Problems (Doug Steele)
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

['69 Camaro]

You're welcome, Marty. You're right to fix the references instead of
keeping the band-aid fix. Fixing the references will avoid other problems
that will manifest themselves whenever VBA code runs.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.