By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,220 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

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

P: n/a
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?
Dec 18 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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?
Dec 18 '06 #2

P: n/a
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.
Dec 18 '06 #3

P: n/a
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

Dec 18 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.