trim() is not valid in query, isnull() is not valid in VBA program

[ArmstrongHe]

Dear Sir,
One ACCESS MBD file is well runing in my computer, but in another computer, also installed with ACCESS2000, with the same MDB file, trim() is not valid in SQL statement of a query, and isnull() is not valid in VBA program. Those two problems are due to the same reason or not? What should I do?
Your kind response would be very appreciated.
Thanks!
Armstrong

 

[RoyVidar]

Goto a code module on the not working machine. Hit Tools | References. There's probably one marked as missing or invalid or something like that. Try deselecting that, and find "the nearest match" - same library with highest version number.

Some additional info can be found:
faq181-936

http://support.microsoft.com/defaul...port/kb/articles/Q194/3/74.ASP&NoWebContent=1

Roy-Vidar

 

[ArmstrongHe]

Hi, Roy,
You are very warm-hearted, thanks for your help. Once I also know someone named Roy, Are you an American?
Regards!
Armstrong