RTrim?

[vbjohn]

This is a strange error. I can not believe I am having so many problems today.

When I am running this query on my computer I have no problems. So when I run it on an end users computer it does not like this statement.

RTrim([ADDRESS]![CITY])+', '+RTrim([ADDRESS]![STATE])+' '+RTrim([ADDRESS]![ZIPCODE])

On my computer: I have Access 2000.
On the end users: Access 97 & Access 2000.

They need Access 97 & Access 2000. Because one other program that they use needs Access 97. And for my application they need Access 2000. STRANGE thing is that my boss also has: Access 97 & Access 2000 and it works fine. Can anyone help suggest what I am doing wrong?



John-

 

[WayneRyan]

John,

Compare the references on the valid and invalid machines.

Wayne

 

[vbjohn]

........

I looked at the references and it looks fine. Both computers are the same.

John-

 

[Vassago]

What is the exact error you are getting?

 

[Pat Hartman]

This error is almost always caused because of a reference error. Check out this link:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

 

[vbjohn]

.....

Well, I check out the reference and it is referenced. So I am not sure if that is the problem.


John-