StrConv Error in Access 200 Query

  • Thread starter Thread starter John Van Dusen
  • Start date Start date
J

John Van Dusen

I own both Office 2000 and Office XP. Professional
version of both. Recently in an Access query in XP I was
trying to convert a field of City names that were all
uppercase to first letter uppercase remaining letters
lower case. I tried to use StrConv([City],3). But all I
got was an "Undefined Function" error. So I uninstalled
Office XP and re-installed 2000 hoping the problem would
not occur in 2000. But it still does. StrConv is listed
in Microsolf Knowledge Base as a "built-in" function. So
how come I can't run a built-in function. When I
installed Office 2000 I intentioanlly tried to install
every option I could so I wouldn't miss anything. As an
aside, when I try to access "Add-Ins" that menu option is
greyed out. I don't know if thjere is any connection
between the two problems. Access Help is NO help with my
particular pronblem.
 
I own both Office 2000 and Office XP. Professional
version of both. Recently in an Access query in XP I was
trying to convert a field of City names that were all
uppercase to first letter uppercase remaining letters
lower case. I tried to use StrConv([City],3). But all I
got was an "Undefined Function" error.
Click to expand...

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.
 
Back
Top