Function isn't available...

[Pekka]

Hi,
I have a following expression in my query:
Kausi:LTrim(Left(Str([LIBL39_EMLCHIS5]![IVDAT8]);7))

when I try to execute the query I get the following error message:Function isn't available in expression in query expression.

If I look at the function list in expr. builder I can see them all. This query has worked before in my other computer. What I have missed when installing Office 97?

 

[nfell]

Hi,

I get the same message every now and then.

To solve it I have to refresh the references used.

Go into any VB code.
Go to Tools -> References
Un-check the ones Access allows, and then click OK.
Go back in and check the ones you use.
Click OK and compile all modules.

Hope it helps.

 

[Pekka]

Thanks, it worked!