E
Earthman
I have an Access application that uses Microsoft Office Web Components to
implement a spreadsheet on a form. This is an application that has been
running correctly for a couple of years on several PCs, but recently began
failing on one PC with several messages saying:
"The expression CommandEnabled you entered as the event property setting
produced the following error: There was an error loading an ActiveX control
on one of your forms or reports."
CommandEnabled is replaced by CommandChecked, CommandTipText, MouseOver,
BeforeKeyup, and others to form the several errors.
I unsuccessfully tried several things to correct this, including:
- Fixing the reference from within VBA (Tools menu: References):
Interestingly enough, Microsoft Office Web Components did not appear in the
list, even though the OWC11.DLL file was in the normal location, so I had to
browse to correct the reference. After doing so I was able to compile the
program, but the error was not corrected.
- Confirming the configuration of OWC11.DLL in the registry in accordance
with a MVP article on the subject that I found on line.
- Re-installing OWC11.DLL by using O2003PIA.EXE in accordance with MS
knowledge base article 897646.
- Confirming that the MS Office installation is the most current service pack.
None of these had any effect. The problem continues.
I believe this is related to the registration of OWC11.DLL because it is not
displayed in the Reference list. Thing is, I don't know what to do about it
- I've tried everything I can think of.
Have I got this right? Does anyone have suggestions?
The subject PC is running MS Office 2003 (11.8166.3221) SP 3 on MS Windows
XP Pro 2002 SP3.
Thanks for your help.
implement a spreadsheet on a form. This is an application that has been
running correctly for a couple of years on several PCs, but recently began
failing on one PC with several messages saying:
"The expression CommandEnabled you entered as the event property setting
produced the following error: There was an error loading an ActiveX control
on one of your forms or reports."
CommandEnabled is replaced by CommandChecked, CommandTipText, MouseOver,
BeforeKeyup, and others to form the several errors.
I unsuccessfully tried several things to correct this, including:
- Fixing the reference from within VBA (Tools menu: References):
Interestingly enough, Microsoft Office Web Components did not appear in the
list, even though the OWC11.DLL file was in the normal location, so I had to
browse to correct the reference. After doing so I was able to compile the
program, but the error was not corrected.
- Confirming the configuration of OWC11.DLL in the registry in accordance
with a MVP article on the subject that I found on line.
- Re-installing OWC11.DLL by using O2003PIA.EXE in accordance with MS
knowledge base article 897646.
- Confirming that the MS Office installation is the most current service pack.
None of these had any effect. The problem continues.
I believe this is related to the registration of OWC11.DLL because it is not
displayed in the Reference list. Thing is, I don't know what to do about it
- I've tried everything I can think of.
Have I got this right? Does anyone have suggestions?
The subject PC is running MS Office 2003 (11.8166.3221) SP 3 on MS Windows
XP Pro 2002 SP3.
Thanks for your help.