469,945 Members | 1,855 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,945 developers. It's quick & easy.

Function is not available in expressions in query expression Error

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
5 5536
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
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
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
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
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.

Similar topics

3 posts views Thread by domeceo | last post: by
8 posts views Thread by Henk van Winkoop | last post: by
4 posts views Thread by uspensky | last post: by
4 posts views Thread by Tony Lownds | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.