M
Marcus
I have inserted on a form an OWC11 chart, did some little coding, added the
reference to OWC11.DLL and compiled.
Now as soon as the form is opened an error is issued
"The expression On Open you entered as the event property setting produced
the following error"
* The expression may not results in the name of a macro, the name of a
user-defined function, or [Event Procedure]
* There may have been an error evaluating the function, event, or macro.
Expanding the "Show Help" button, the following is displayed:
***********************************************
"Visual Basic for Applications (VBA) encountered a problem while attempting
to access a property or method. The problem may be one of the following:
A reference is missing.
For help restoring missing references, see the Microsoft Knowledge Base
article 283806.
An Expression is misspelled.
Check all expressions used in event properties for correct spelling.
A user-defined function is declared as a sub or as a private function in a
module.
Expressions can resolve a user-defined function only if the function is
declared as one of the following:
A public function in a module
A public or private function in a code module of the current form or report
Security in Access is set to Medium or High and the Microsoft Jet 4.0 SP8
update is not installed.
A more recent verion of Jet 4.0 must be installed for Access to function
properly when security is set to Medium or High. To obtain the latest
version of Microsoft Jet, go to Windows Update."
***********************************************
Now if
- I simply remove the OWC chart from the form, save and run, no errors
- Commenting the whole sub containing the OWC code, gives the error
- removed the reference to OWC11, and added again, gives error
- decompiled the project and recompiled gives error.
I wonder if there's any security issue such as the OWC11.DLL is being
restricted from Vista it self...
Any help?
Thanks
reference to OWC11.DLL and compiled.
Now as soon as the form is opened an error is issued
"The expression On Open you entered as the event property setting produced
the following error"
* The expression may not results in the name of a macro, the name of a
user-defined function, or [Event Procedure]
* There may have been an error evaluating the function, event, or macro.
Expanding the "Show Help" button, the following is displayed:
***********************************************
"Visual Basic for Applications (VBA) encountered a problem while attempting
to access a property or method. The problem may be one of the following:
A reference is missing.
For help restoring missing references, see the Microsoft Knowledge Base
article 283806.
An Expression is misspelled.
Check all expressions used in event properties for correct spelling.
A user-defined function is declared as a sub or as a private function in a
module.
Expressions can resolve a user-defined function only if the function is
declared as one of the following:
A public function in a module
A public or private function in a code module of the current form or report
Security in Access is set to Medium or High and the Microsoft Jet 4.0 SP8
update is not installed.
A more recent verion of Jet 4.0 must be installed for Access to function
properly when security is set to Medium or High. To obtain the latest
version of Microsoft Jet, go to Windows Update."
***********************************************
Now if
- I simply remove the OWC chart from the form, save and run, no errors
- Commenting the whole sub containing the OWC code, gives the error
- removed the reference to OWC11, and added again, gives error
- decompiled the project and recompiled gives error.
I wonder if there's any security issue such as the OWC11.DLL is being
restricted from Vista it self...
Any help?
Thanks