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

Function is not available in expressions in query expression Error

P: n/a
Hello

A person developed a Microsoft Access Solution and gave me the MDE
file. When I tried to run it, I got "Function is not available in
expressions in query expression 'Trim([......" Error.

I learnt from the Microsoft Website and from this Group that this is
problem is the result of a mismatch between the Computer where this
database was developed and compiled on and the Computer where I am
trying to run it.

Is there a way to fix this issue without getting the original MDB
file?

Thank you.

Aug 28 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
On Tue, 28 Aug 2007 13:37:18 -0000, el**************@gmail.com wrote:

If it happened at startup time it's most likely a Missing Reference
problem, and the way to find out which one is missing is to have the
MDB, look at a code window, and select Tools References.

You can write code to check for references at startup time, but that's
a somewhat advanced topic and apparently not done in your app.

-Tom.

>Hello

A person developed a Microsoft Access Solution and gave me the MDE
file. When I tried to run it, I got "Function is not available in
expressions in query expression 'Trim([......" Error.

I learnt from the Microsoft Website and from this Group that this is
problem is the result of a mismatch between the Computer where this
database was developed and compiled on and the Computer where I am
trying to run it.

Is there a way to fix this issue without getting the original MDB
file?

Thank you.
Aug 28 '07 #2

P: n/a
I have the below references checked, However, how can I know of any
other missing references? -Thanks

Visual Basic For Aplications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Library
Microsoft ActiveX Data Objects 2.1 Library

-------------------------------------------------------------------------------------------------------------------------------------------------------------------
On Aug 28, 4:16 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Tue, 28 Aug 2007 13:37:18 -0000, elie.constant...@gmail.com wrote:

If it happened at startup time it's most likely a Missing Reference
problem, and the way to find out which one is missing is to have the
MDB, look at a code window, and select Tools References.

You can write code to check for references at startup time, but that's
a somewhat advanced topic and apparently not done in your app.

-Tom.
Hello
A person developed a Microsoft Access Solution and gave me the MDE
file. When I tried to run it, I got "Function is not available in
expressions in query expression 'Trim([......" Error.
I learnt from the Microsoft Website and from this Group that this is
problem is the result of a mismatch between the Computer where this
database was developed and compiled on and the Computer where I am
trying to run it.
Is there a way to fix this issue without getting the original MDB
file?
Thank you.

Aug 28 '07 #3

P: n/a
On Tue, 28 Aug 2007 14:32:39 -0000, el**************@gmail.com wrote:

They would be marked as Missing in that same window.

It's unusual (though not illegal) to have both DAO and ADO selected.

Can you give us the entire SQL statement?

-Tom.
>I have the below references checked, However, how can I know of any
other missing references? -Thanks

Visual Basic For Aplications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Library
Microsoft ActiveX Data Objects 2.1 Library

-------------------------------------------------------------------------------------------------------------------------------------------------------------------
On Aug 28, 4:16 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
>On Tue, 28 Aug 2007 13:37:18 -0000, elie.constant...@gmail.com wrote:

If it happened at startup time it's most likely a Missing Reference
problem, and the way to find out which one is missing is to have the
MDB, look at a code window, and select Tools References.

You can write code to check for references at startup time, but that's
a somewhat advanced topic and apparently not done in your app.

-Tom.
>Hello
>A person developed a Microsoft Access Solution and gave me the MDE
file. When I tried to run it, I got "Function is not available in
expressions in query expression 'Trim([......" Error.
>I learnt from the Microsoft Website and from this Group that this is
problem is the result of a mismatch between the Computer where this
database was developed and compiled on and the Computer where I am
trying to run it.
>Is there a way to fix this issue without getting the original MDB
file?
>Thank you.
Aug 29 '07 #4

P: n/a
On Aug 29, 4:05 am, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Tue, 28 Aug 2007 14:32:39 -0000, elie.constant...@gmail.com wrote:

They would be marked as Missing in that same window.

It's unusual (though not illegal) to have both DAO and ADO selected.

Can you give us the entire SQL statement?

-Tom.
I have the below references checked, However, how can I know of any
other missing references? -Thanks
Visual Basic For Aplications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Library
Microsoft ActiveX Data Objects 2.1 Library
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
On Aug 28, 4:16 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Tue, 28 Aug 2007 13:37:18 -0000, elie.constant...@gmail.com wrote:
If it happened at startup time it's most likely a Missing Reference
problem, and the way to find out which one is missing is to have the
MDB, look at a code window, and select Tools References.
You can write code to check for references at startup time, but that's
a somewhat advanced topic and apparently not done in your app.
-Tom.
Hello
Hi Tom

I don't have the SQL Statement as it's an MDE file but I can see part
of it in the error message. it is: Function is not available in
expression in query expression 'TRIM([ContactFName] & " " &
[ContactMName] & " " & [ContactLName])

Regards
Elie
>
A person developed a Microsoft Access Solution and gave me the MDE
file. When I tried to run it, I got "Function is not available in
expressions in query expression 'Trim([......" Error.
I learnt from the Microsoft Website and from this Group that this is
problem is the result of a mismatch between the Computer where this
database was developed and compiled on and the Computer where I am
trying to run it.
Is there a way to fix this issue without getting the original MDB
file?
Thank you.

Aug 30 '07 #5

P: n/a
If you only have the MDE file, how have you checked to see what references
are checked? You can only do this, to my knowledge, by going into the code
window for any form in the db and opening References, which you can't do from
an MDE file. The only function showing in the error message is *Trim*, which
is part of the Visual Basic for Applications library.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200708/1

Aug 30 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.