I getting the following error message when I try and open the my access app on another pc which also has access 2000 sr1 installed. The pc that I used to develop the app is also running 2000 sr1

“Function is not available in expression in query expression ‘left(fsokey,6’”

Hello,

Just a guess. Check your references. Open a new module goto 'Tools' and 'References' and check them. They must be equal to the develop pc.

Greetings,

Albert

[This message has been edited by raindrop3 (edited 01-10-2002).]

I figured it out. Im accustomed to seeing these errors in VB6 when a reference is missing. All I do is check the missing references. But in Access when you have a reference checked but not using it you get the error I was getting. But there is nothing in the reference list to let you know you have to uncheck it. It was pure trial and error. I hope this helps someone in the future.

Thansk for the replys

I read the reply with interest as I get the error frequently on my work;s network. It only seems to happen on certain pc's and I have unclicked the references missing boxes I sometimes get the error again. If I can solve this once and for all - great