Function is not available in expressions in query expression Error

[elie.constantine]

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.

[Tom van Stiphout]

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.

[elie.constantine]

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 <[e-mail]:

On Tue, 28 Aug 2007 13:37:18 -0000, [e-mail] 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.

[Tom van Stiphout]

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 <[e-mail]:

>On Tue, 28 Aug 2007 13:37:18 -0000, [e-mail] 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.

[elie.constantine]

On Aug 29, 4:05 am, Tom van Stiphout <[e-mail]:

On Tue, 28 Aug 2007 14:32:39 -0000, [e-mail] 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 <[e-mail]:

On Tue, 28 Aug 2007 13:37:18 -0000, [e-mail] 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.

[Linq Adams via AccessMonster.com]

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