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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pw - 05 Apr 2006 01:08 GMT

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

Reply to this Message

Jeremy Wallace - 05 Apr 2006 01:14 GMT

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

> Hi,
>
[quoted text clipped - 10 lines]
>
> use paul at williamsonenterprises dot com for e-mail

Reply to this Message

pw - 05 Apr 2006 03:23 GMT

>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
>
[quoted text clipped - 12 lines]
>>
>> use paul at williamsonenterprises dot com for e-mail

-pw

use paul at williamsonenterprises dot com for e-mail

Reply to this Message

F1Radzio - 05 Apr 2006 10:18 GMT

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 !!!

Reply to this Message