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

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

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


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


Apr 5 '06 #2

P: n/a
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
Apr 5 '06 #3

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

Apr 5 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.