M
Maartin
HI all,
I see only two other people has encountered similar problems but
nobody got any answers.
Here is the error I get:
The expression On Click you entered as the event property setting
produced the following error: A problem occurred while
Microsoft Office Access was communicating with the OLE server or
ActiveX Control.
* The expression may not result in the name of the macro, the name of
a user-defined function or [Event Procedure].
* There may have been an error evaluating the function, event, or
macro.
AFTER CLICK on "Show Help >>"
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 version 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.
All I have a database that has got linked tables. I designed a form
and dropped a button on it, when I try to link any code to the button
click (VBA) I get this error. The code in VBA is generated by Access,
I even tried to create my own method (private or public) but I get the
same error. The only way that I can get the button to do anything is
to create a macro that does it.
I check references everything, now here is the thing that blows my
lid.
I have a similar Access application on my PC (not developed on my pc);
it also features a form (just like mine) and has a button (just like
mine) and when you click on that one IT WORKS!!!! How the #@$%^ ? I
check the references between the projects everything. Everything is
the same except for that table(s) structure in the database.
Can anybody explain that one to me ? I have tried creating a new
database, repair and compact everything that I could think of but
nothing has solved this idiotic error. This includes setting security
to low (which I know is not the issue) and installing msjet blah-blah
SP 8 (which I know is not the issue either) and nothing seems to work.
ANYBODY PLEASE help, before I kick access and start the process of
telling the client more money please and lets develop this application
in VB.NET and SQL 2000.
I see only two other people has encountered similar problems but
nobody got any answers.
Here is the error I get:
The expression On Click you entered as the event property setting
produced the following error: A problem occurred while
Microsoft Office Access was communicating with the OLE server or
ActiveX Control.
* The expression may not result in the name of the macro, the name of
a user-defined function or [Event Procedure].
* There may have been an error evaluating the function, event, or
macro.
AFTER CLICK on "Show Help >>"
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 version 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.
All I have a database that has got linked tables. I designed a form
and dropped a button on it, when I try to link any code to the button
click (VBA) I get this error. The code in VBA is generated by Access,
I even tried to create my own method (private or public) but I get the
same error. The only way that I can get the button to do anything is
to create a macro that does it.
I check references everything, now here is the thing that blows my
lid.
I have a similar Access application on my PC (not developed on my pc);
it also features a form (just like mine) and has a button (just like
mine) and when you click on that one IT WORKS!!!! How the #@$%^ ? I
check the references between the projects everything. Everything is
the same except for that table(s) structure in the database.
Can anybody explain that one to me ? I have tried creating a new
database, repair and compact everything that I could think of but
nothing has solved this idiotic error. This includes setting security
to low (which I know is not the issue) and installing msjet blah-blah
SP 8 (which I know is not the issue either) and nothing seems to work.
ANYBODY PLEASE help, before I kick access and start the process of
telling the client more money please and lets develop this application
in VB.NET and SQL 2000.