missing dll's

[specsol]

I am building a database for a large charity on a voluntary basis. My machine has Access 2002. The charity has just supplied me with a laptop with access 2003 to develop the database. Code which works on my access 2002 machine throws up errors on access 2003, (broken or missing references to controls.dll) This turns out to be because the 2003 cannot handle the CHR(13) I use to split lines in msgbox. Also in queries it cannot process the DATE() function. The query works in 2003 if I replace it with NOW(). I conclude on the basis of this and other observations that their IT department has set it up without a DLL. Does anyone know if CHR & DATE are in some DLL and NOW in another and if so which? The only controls.dll on my machine belongs to Nero Wave Editor which seems unlikely to be necessary for access. There is no controls.dll on the laptop. comctl32.dll which seemed likely is on both machines (with same version)

Apologies, I originally posted this on the Forms forum. More relevant here

 

[Pat Hartman]

The problem is the old missing references issue. Whenever you move a database from one computer to another or install new software, you can potentially run into strange problems. Integral functions such as Date() seem to not work. There are many other symptoms depending on what changed in the environment.

To solve the problem, open any code module. In the VB IDE, click on Tools/References. Look for something that says MISSING. If you don't see the problem imediately, compare the list of references that show on the version that works to the list for the version that doesn't work. Once you navigate to the new location for the missing reference or install the missing .dll if that is the case, the strange behaviour will cease.

 

[specsol]

Missing dll's

Thanks for your reply. I had already done this but when I looked at Tools/Reference, it is grayed out. That is why I was hoping someone would know likely DLL's which I could check on the machines.

 

[specsol]

Missing dll's (I'm wrong!)

Ignore my last reply! I had (stupid I know but I am a new user of Access) gone into tools/reference from the VBA window showing the compile error with the CHR function rather than going directly through the Code access butto. When I do this I can use Tools/Access, see the missing references. Unchecking them gets rid of the problem. They were references from my Nero 8 software and a Psion connect system on my own machine and nothing to do with Access.