I wrote some VBA code in Access. There are some basic functions like Date(), Left(), Right(),String(). It works fine on my computer. but after I ran it on another computer, it crashed when it came to these functions. It seems the computer can't recognize those functions. What is the problem and what should i do to fix it?

Your help is highly appreciated!

Try checking the references section in your VBA source code editor - to get to this, you can go to any code-behind-forms, code-behind-reports, or any module and then select Tools | References.

Be sure that at least "Visual Basic for Applications" is present in the list and checked. It would probably also be helpful to check "Microsoft Access x.x Object Library" (x.x refers to the current version of Access - AccessXP uses 10.0), "OLE Automation", and "Microsoft ActiveX Data Objects 2.1 Library" as well.

Once you have selected the items, go ahead and click the [OK] button. That, in most cases, should take care of the problem.

Good luck.

Warren
:D

make sure that under references there are no items marked as missing.



Sal

Good point - thanks, Sal.