An Error I have no idea how to fix....

[denileigh]

Yesterday I redesigned some of the forms in our database and all was working fine. It works fine on every pc in the office except 1.

On his pc he gets the following error when opening the database:

"An error occurred while loading form_ContractChargessub. Do you wish to continue?"

If you choose yes the database will open but it doesn't work. I have no idea how to even begin to solve this problem.

I did notice that he was running Access 2003 and everyone else is on 2002. Could this be the problem?

Thanks for any help you can give.

Dianne

 

[The_Doc_Man]

Possibly a reference problem. You might wish to search this forum for instructions on how to open a database in a way that bypasses the startup form. The only way to fix a reference problem is to open the DB, get to any code page (class or general module), and use the Tools menu bar option to get to the references list. Search this forum for "References" while you are at it.

 

[denileigh]

Do they have to match? I checked there and one is running Microsoft Access10.0 and the other is running Microsoft Access 11.0.

 

[The_Doc_Man]

"References" aren't the versions of Access you are running but the secondary library files (.DLL, .OCX, and the like) that provide supplementary services.

These are defined in the Windows Registry so they are unique to each system. Further, it very well COULD occur that different versions of Access require different .DLL files. For instance, when you changed from AC97 to AC2K, you got a MAJOR difference in some the text manipulation libraries. Whole new versions of the library, not just patches.

Search the forum for "References" for details on how to find and fix such problems. It isn't that hard to find. Might be harder to fix.

 

[denileigh]

I must be doing something wrong...when I did a search for references...this was the only post that came up. UGH!

I did find out that we are running MSACC 10.0 and he has MSACC11.0. Could that be it?

 

[jkl0]

Hold down the shift key while opening the database
from the menu at the top choose

Tools - Macros - Visual Basic Editor

This will open up the Visual Basic code window. Then choose

Tools - References

From this pop-up you can check for missing references.