+ Reply to Thread
Results 1 to 6 of 6

Function is not available in expressions in query expression Error

  1. 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.


  2. Re: Function is not available in expressions in query expression Error

    On Tue, 28 Aug 2007 13:37:18 -0000, elie.constantine@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.



  3. Re: Function is not available in expressions in query expression Error

    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 wrote:
    > 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.




  4. Re: Function is not available in expressions in query expression Error

    On Tue, 28 Aug 2007 14:32:39 -0000, elie.constantine@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 wrote:
    >> 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.

    >



  5. Re: Function is not available in expressions in query expression Error

    On Aug 29, 4:05 am, Tom van Stiphout wrote:
    > 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 wrote:
    > >> 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.




  6. Re: Function is not available in expressions in query expression Error

    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


+ Reply to Thread