Access 2003: Function is not available in expressions in query expression 'Trim([city] & ", " & [stateorprovince])'.

[pw]

Hi,

I created and distributed an Access 2003 MDE. When the user opens up
a form he get's an error message :Function is not available in
expressions in query expression 'Trim([city] & ", " &
[stateorprovince])'.

It works fine at other clients.

How can I resolve this? I do not see anything in the MS KB.

-pw

use paul at williamsonenterprises dot com for e-mail

[Jeremy Wallace]

Paul,

This is a references issue.

Have the user hit ctrl-g and then tools|references. Then do a comparo
with the references you've got set.

Jeremy

pw wrote:

Hi,

I created and distributed an Access 2003 MDE. When the user opens up
a form he get's an error message :Function is not available in
expressions in query expression 'Trim([city] & ", " &
[stateorprovince])'.

It works fine at other clients.

How can I resolve this? I do not see anything in the MS KB.

-pw

use paul at williamsonenterprises dot com for e-mail

[pw]

On 4 Apr 2006 17:14:21 -0700, "Jeremy Wallace"
<je************@gmail.com> wrote:

Paul,

This is a references issue.

Have the user hit ctrl-g and then tools|references. Then do a comparo
with the references you've got set.

Geesh! I didn't it was possible to use Ctrl-G with and MDE file! Phew,
looks like you can't view code or references.

What is was Jeremy is that my wife included a reference to the
snapshot viewer. I removed it and created a new mde and sent it off
to them and it worked. I bet they didn't have Office installed.

I thought when creating a distributable product that the program would
include everything needed.

-paul

Jeremy

pw wrote:

Hi,

I created and distributed an Access 2003 MDE. When the user opens up
a form he get's an error message :Function is not available in
expressions in query expression 'Trim([city] & ", " &
[stateorprovince])'.

It works fine at other clients.

How can I resolve this? I do not see anything in the MS KB.

-pw

use paul at williamsonenterprises dot com for e-mail

-pw

use paul at williamsonenterprises dot com for e-mail

[F1Radzio]

To resolve this problem:
- write our own Trim function like:

Public Function MyTrim (MyString as String)
MyTrim=Trim(MyString)
End Function

And use your MyTrim not standard Trim in your queries.

That is all !!!