undefined function UCase in expression

M

MartyS

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
 
T

Tom Wickerath

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
__________________________________________
 
6

'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.
 
M

MartyS

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.
 
M

MartyS

Thank you Tom. I will check the sites out.

Tom Wickerath said:
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
__________________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top