Access Query Problem

[cenderawasih]

HI....

i have developed Access form that is bound to a query. The query has a Mid([]) and Left([]) expression that i use to rearranged a string of numbers position. The query runs OK from my PC (windows 98 and office 2000) and some other PC. But there are many PCs that gives error when i run the query.The error msg is:

"Function is not available in expression in query expression Mid([MYNUMBER],5,2)....."

Can somebody tells me what is wrong...because there are some PC that can run the query and there are also PCs that cannot.......and to make it worst...the PC that cannot run the query are the user's PCs....where the OS is also windows 98 and have office 2000.......

I'm very sure that the expression sintaks is OK because if not it would not run at any PC at all........I can't figure it out how to solve this problem......

please help

 

[BobAtHome]

Since it runs on some PCs but not on others, I would suspect that a reference is not in the directory it should be on the machines where it does not work. On your computer open a module in design view. On the menu bar , click on tools and select references. You will notice some are selected. If you click on the name you will see the location they should be in. Make note of each reference that is selected and their location on your computer and make sure the users are the same.

 

[cenderawasih]

Thanks bob...u really are a big help!