Hello,
I use a left function on a field in a query.  This works fine on my PC, 
but when I use the same query (same program) on an other PC (same Access 
2000), this Left function doesn't work.  What can I do to solve this?

Hi
check your not missing a reference on the other machine, I've had this where
access didn't understand the trim or str function and is was a missing
reference to the comctrl32.ocx, if I remember correctly.

It might be due that the other machine doesn't have something installed,
which is giving you a missing reference, which in turn is stopping the left
function from working

Duncan
MCP,MCSD,AMIAP

-----Original Message-----
From: Steven Van Aken [mailto:svanaken@m...]
Sent: 29 April 2002 14:09
To: Access
Subject: [access] Left function


Hello,
I use a left function on a field in a query.  This works fine on my PC,
but when I use the same query (same program) on an other PC (same Access
2000), this Left function doesn't work.  What can I do to solve this?

Hello Steven,

It's a while since I had that problem but I suspect it has something to do
with the references on the second PC.

If you open a module in the database on the problem PC then click Tools then
References you should see a list of available references for that database.

I think "Left" is an excel one so you have to have the Microsoft Excel
object library showing.

If it's not ticked scroll down to find it and tick it.

Good luck



Regards

Richard Gibson
IT Manager


The information in this message is confidential and intended for the
addressee only.  If you have received this message in error please delete
and notify the sender, any other action may be unlawful.

The views expressed in this message are personal and not necessarily those
of Walkerpack Ltd unless explicitly stated.


-----Original Message-----
From: Steven Van Aken [mailto:svanaken@m...]
Sent: 29 April 2002 15:09
To: Access
Subject: [access] Left function


Hello,
I use a left function on a field in a query.  This works fine on my PC, 
but when I use the same query (same program) on an other PC (same Access 
2000), this Left function doesn't work.  What can I do to solve this?

Thanks Duncan, it works.  Can I check this through VBA when I start the 
application?
 
Hi
check your not missing a reference on the other machine, I've had this 
where
access didn't understand the trim or str function and is was a missing
reference to the comctrl32.ocx, if I remember correctly.

It might be due that the other machine doesn't have something installed,
which is giving you a missing reference, which in turn is stopping the left
function from working

Duncan
MCP,MCSD,AMIAP

-----Original Message-----
From: Steven Van Aken [mailto:svanaken@m...]
Sent: 29 April 2002 14:09
To: Access
Subject: [access] Left function


Hello,
I use a left function on a field in a query.  This works fine on my PC,
but when I use the same query (same program) on an other PC (same Access
2000), this Left function doesn't work.  What can I do to solve this?