I've been rolling out a database now for about 1.5 years...

[MLH]

Today, I rolled out mods to an mde I've been using for a
long time. I got an error saying
Error #3075
Function isn't available in expressions in query expression
UCase([SerialNum])

Here's the SQL ==it hasn't changed in about a year...
UPDATE tblVehicleJobs SET tblVehicleJobs.SerialNum =
UCase([SerialNum]), tblVehicleJobs.TagNum = UCase([TagNum]),
tblVehicleJobs.TagState = UCase([TagState]),
tblVehicleJobs.InspStickNum = UCase([InspStickNum]),
tblVehicleJobs.InspStickState = UCase([InspStickState]),
tblVehicleJobs.LocState = UCase([LocState]),
tblVehicleJobs.DMVFileNumber = UCase([DMVFileNumber]),
tblVehicleJobs.SaleType = UCase([SaleType]) WHERE
((tblVehicleJobs.SerialNum) Is Not Null) OR ((tblVehicleJobs.TagNum)
Is Not Null) OR ((tblVehicleJobs.TagState) Is Not Null) OR
((tblVehicleJobs.InspStickNum) Is Not Null) OR
((tblVehicleJobs.InspStickState) Is Not Null) OR
((tblVehicleJobs.LocState) Is Not Null) OR
((tblVehicleJobs.DMVFileNumber) Is Not Null) OR
((tblVehicleJobs.SaleType) Is Not Null);

Is it likely that my runtime installation has been screwed up?
It was working before I downloaded the data, put it in the new
mde and stuck it back out on the remote system. This happened
in two remote installations. Is this corruption?

[BerkshireGuy]

Try this:

Go into the VBA editor, click on Tool and then References. See if you
have any broken references. Sometimes broken references causes odd
messages like this.

-=Brian

MLH wrote:

Today, I rolled out mods to an mde I've been using for a
long time. I got an error saying
Error #3075
Function isn't available in expressions in query expression
UCase([SerialNum])

Here's the SQL ==it hasn't changed in about a year...
UPDATE tblVehicleJobs SET tblVehicleJobs.SerialNum =
UCase([SerialNum]), tblVehicleJobs.TagNum = UCase([TagNum]),
tblVehicleJobs.TagState = UCase([TagState]),
tblVehicleJobs.InspStickNum = UCase([InspStickNum]),
tblVehicleJobs.InspStickState = UCase([InspStickState]),
tblVehicleJobs.LocState = UCase([LocState]),
tblVehicleJobs.DMVFileNumber = UCase([DMVFileNumber]),
tblVehicleJobs.SaleType = UCase([SaleType]) WHERE
((tblVehicleJobs.SerialNum) Is Not Null) OR ((tblVehicleJobs.TagNum)
Is Not Null) OR ((tblVehicleJobs.TagState) Is Not Null) OR
((tblVehicleJobs.InspStickNum) Is Not Null) OR
((tblVehicleJobs.InspStickState) Is Not Null) OR
((tblVehicleJobs.LocState) Is Not Null) OR
((tblVehicleJobs.DMVFileNumber) Is Not Null) OR
((tblVehicleJobs.SaleType) Is Not Null);

Is it likely that my runtime installation has been screwed up?
It was working before I downloaded the data, put it in the new
mde and stuck it back out on the remote system. This happened
in two remote installations. Is this corruption?

[MLH]

That's exactly what it was. This same problem
has bit me in the ass twice in the past several
months. Its just so non-descript, the error msgs.
I'll just have to remember to check the ref's.

[AccessVandal via AccessMonster.com]

Hi,

Where is this running from? A standard access query? or From a VB code?

Something is not right. "tblVehicleJobs.SerialNum = UCase([SerialNum])"

Trying to Update from the same table? Doesn't appear normalize to me.

If you run the code in VB, use the Debug.Print strSQL, than look at the
syntax in the immeadiate window.

>MLH wrote:
Today, I rolled out mods to an mde I've been using for a
long time. I got an error saying
Error #3075
Function isn't available in expressions in query expression
UCase([SerialNum])

Here's the SQL ==it hasn't changed in about a year...
UPDATE tblVehicleJobs SET tblVehicleJobs.SerialNum =
UCase([SerialNum]), tblVehicleJobs.TagNum = UCase([TagNum]),
tblVehicleJobs.TagState = UCase([TagState]),
tblVehicleJobs.InspStickNum = UCase([InspStickNum]),
tblVehicleJobs.InspStickState = UCase([InspStickState]),
tblVehicleJobs.LocState = UCase([LocState]),
tblVehicleJobs.DMVFileNumber = UCase([DMVFileNumber]),
tblVehicleJobs.SaleType = UCase([SaleType]) WHERE
((tblVehicleJobs.SerialNum) Is Not Null) OR ((tblVehicleJobs.TagNum)
Is Not Null) OR ((tblVehicleJobs.TagState) Is Not Null) OR
((tblVehicleJobs.InspStickNum) Is Not Null) OR
((tblVehicleJobs.InspStickState) Is Not Null) OR
((tblVehicleJobs.LocState) Is Not Null) OR
((tblVehicleJobs.DMVFileNumber) Is Not Null) OR
((tblVehicleJobs.SaleType) Is Not Null);

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200612/1