Ucase error

[Ashish Nanda]

I am trying to run a query which has the function ucase
in the selct i mean i am prompting the user for say an
item so i am using ucase([Enter the item]).
But it gives me an error saying it can not find the
function ucase.
But i am using the same function in a different
applicaion and it works there.
What could be the reason
Best Regards,
ashish

 

[May]

First, can you have to show your SQL statment, otherwise,
have no clue what happen, it works find on my side,
Second, the function for user to key in has no meaning
because when users hit enter, they have no way to see it
change from small letter to capital.
what you should really do is to create an entry form and
let the user key in, but when they key in any letter,
every letter will change to capital immediately.

May
MCP in Access and SQL Server

 

[Ashish Nanda]

I am sending the code for the query...

SELECT IMAN_IMPARAMS.ITEM, IMAN_IMPARAMS.STKLOC,
IMAN_IMPARAMS.ORDERCYCLE, IMAN_IMPARAMS.LEADTIME,
IMAN_IMPARAMS.EST_SALES, IMAN_IMPARAMS.PRODCAT,
IMAN_IMPARAMS.DESCRIPTION, IMAN_IMPARAMS.MEMO,
IMAN_IMPARAMS.FLAG
FROM IMAN_IMPARAMS
WHERE (((IMAN_IMPARAMS.ITEM)=UCase([ENTER THE ITEM])));


The error it gives is undefined function Ucase in
expression.

But i can run the same code on a different machine and it
runs perfect.
The same function is used by me in other programs in the
select statement and it works fine.
I am really confused with this.??/

Ashish

-----Original Message-----
First, can you have to show your SQL statment, otherwise,
have no clue what happen, it works find on my side,
Second, the function for user to key in has no meaning
because when users hit enter, they have no way to see it
change from small letter to capital.
what you should really do is to create an entry form and
let the user key in, but when they key in any letter,
every letter will change to capital immediately.

May
MCP in Access and SQL Server

-----Original Message-----
I am trying to run a query which has the function ucase
in the selct i mean i am prompting the user for say an
item so i am using ucase([Enter the item]).
But it gives me an error saying it can not find the
function ucase.
But i am using the same function in a different
applicaion and it works there.
What could be the reason
Best Regards,
ashish
.

.

 

[Ashish Nanda]

My problem is really driving me crazy. I checked the
refernces and they are all there.
Moreover the same function works in any other access
application i am designing but not this one.
Its the same thing but a new program and everything else
id the same as well.

The prgram runs fine on another machine and accepts the
same function i.e ucase.
I am usung it for loading my data in the query and string
comparison needs to be done in there for uppercase that
is why i need it but it is wierd i mean for this
particular application is i have this proble for. the
same machine the same access and a diffrent application
runs the ucase funtion fine.

Best regards,
Ashish

-----Original Message-----
If you are using 2000 or beyond. It sounds like you are
missing some library.
Go to Visual Basic Editor or Ctrl+G (VBE, Modules and
Design will get you there). Click on "Tools"
and "Reference". Check to see what you have. This is
what I have checked when I open my VBE.

- Visual Basic For Aplications
- Microsoft Access 9.0 Object Library
- OLE Automation
- Microsoft ActiveX Data Objects 2.1 Library
- Microsoft DAO 3.6 Object Library

Hope this will help.

-----Original Message-----
I am trying to run a query which has the function ucase
in the selct i mean i am prompting the user for say an
item so i am using ucase([Enter the item]).
But it gives me an error saying it can not find the
function ucase.
But i am using the same function in a different
applicaion and it works there.
What could be the reason
Best Regards,
ashish
.

.

 

[John Vinson]

My problem is really driving me crazy. I checked the
refernces and they are all there.

And none of them are marked MISSING?

It still sounds like a bad reference. Access won't always display them
all. Try this: open the VBA editor, select View... References, and
check any unchecked reference. Close and open Access, go back into
References, and uncheck it. This will force the program to relink all
its libraries.

If this still doesn't work, it's possible that you have a Field or a
Control named "Ucase" and Access is getting confused.

Another possible getaround: instead of UCase([fieldname]), try
StrConv([fieldnamd], 2). They do the same thing.