Function not available in expressions in query expression?! 
Author Message
 Function not available in expressions in query expression?!

Hi all,

Recenlty I decided to open up an access database I haven't used for a while.
When I tried to run a predefined query I got the error 'Function not
available in expressions in query expressions' with the expression between
parantheses behind it. This used to work and this error even appears when I
do very simple text functions like rtrim$ on a string field.

I haven't got a clue what is wrong here. As mentioned this used to work. I
have reinstalled my PC a while ago, but office was installed fully.

Any help is appreciated!

Misha



Sat, 06 Dec 2003 22:13:34 GMT  
 Function not available in expressions in query expression?!

Quote:

> Hi all,

> Recenlty I decided to open up an access database I haven't used for a while.
> When I tried to run a predefined query I got the error 'Function not
> available in expressions in query expressions' with the expression between
> parantheses behind it. This used to work and this error even appears when I
> do very simple text functions like rtrim$ on a string field.

> I haven't got a clue what is wrong here. As mentioned this used to work. I
> have reinstalled my PC a while ago, but office was installed fully.

> Any help is appreciated!

> Misha

This is a references problem, have a look here for the solution:

http://www.mvps.org/access/bugs/

and look at the first item

Hope this helps

Tony Oakley



Sat, 06 Dec 2003 22:51:41 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Function is not available in expressions in query expression

2. Function is not available in expressions in query expression

3. Function is not available in expressions in query expression

4. Function is not available in expressions in query expression

5. Help: Function isn't available in expression query expression

6. Function isn't available in expressions in query expression

7. Function isn't available in expressions in query expressions

8. FIXED - Function isn't available in expressions in query expression

9. Function isn't available in expressions in query expression

10. Error 3075: function isn't available in expressions in query expression


 
Powered by phpBB® Forum Software © phpBB Group