M
Mr. Smith
Hi all.
Major problem here. I have temporarily inherited an Access front end/SQL
back end app connected via ODBC. I am free to develop anything I need to
however when I pass the mdb file onto other users (either as mdb or mde) I
get this error when a button on the startup form is clicked:
"The expression On Click you entered as the event property setting produced
the following error: Object does not support this property or method."
Then goes on say this:
"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."
The app compiles AOK and the offending line of code that fails is:
"ctl.BackColor = QBColor(10)"
and I have tried
"ctl.BackColor = 65280 "
to overcome it. Jet 4.0 service pack 8 comes with "sandbox" mode which
prohibits certain Access functions running as I found in this document:
http://support.microsoft.com/kb/294698/en-us
I therefore upgraded a couple of users Jet installation to the same verion
as mine (4.0.8227.0) for testing yet they still get the same problem. I have
tried altering the Sandbox mode settings as described in the above document
but to no avail. There are no missing references getting in the way either
and I have eliminating all unnecessary references in testing too. I have
been inclined to wonder if its corruption but I can use it and I have been
able to use it on one other users PC when logged on as myself.
I may be hideously off the mark by suspecting Jet but thus far all things
(and it ain't many) have pointed me that way. ALSO this had been working
just fine then one afternoon - blam! - it just cut in and happened (This
happen to be a tuesday which is the day MS patch releases hit the desktops in
this org). I had handed out a new version and of the front end but no mods
had been made to this form at all.
I have been through every setting I can think of (I'm an Access developer of
nearly 10yrs) both on the server side and the client side but cannot figure
out what is getting in the way here. I have trawled the MS site and
Googled like a madman but I can't even find anything that sounds remotely
like the issue I'm having. Is there an Access scientist out there who knows
what could be causing this?
Cheers
Andrew
Major problem here. I have temporarily inherited an Access front end/SQL
back end app connected via ODBC. I am free to develop anything I need to
however when I pass the mdb file onto other users (either as mdb or mde) I
get this error when a button on the startup form is clicked:
"The expression On Click you entered as the event property setting produced
the following error: Object does not support this property or method."
Then goes on say this:
"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."
The app compiles AOK and the offending line of code that fails is:
"ctl.BackColor = QBColor(10)"
and I have tried
"ctl.BackColor = 65280 "
to overcome it. Jet 4.0 service pack 8 comes with "sandbox" mode which
prohibits certain Access functions running as I found in this document:
http://support.microsoft.com/kb/294698/en-us
I therefore upgraded a couple of users Jet installation to the same verion
as mine (4.0.8227.0) for testing yet they still get the same problem. I have
tried altering the Sandbox mode settings as described in the above document
but to no avail. There are no missing references getting in the way either
and I have eliminating all unnecessary references in testing too. I have
been inclined to wonder if its corruption but I can use it and I have been
able to use it on one other users PC when logged on as myself.
I may be hideously off the mark by suspecting Jet but thus far all things
(and it ain't many) have pointed me that way. ALSO this had been working
just fine then one afternoon - blam! - it just cut in and happened (This
happen to be a tuesday which is the day MS patch releases hit the desktops in
this org). I had handed out a new version and of the front end but no mods
had been made to this form at all.
I have been through every setting I can think of (I'm an Access developer of
nearly 10yrs) both on the server side and the client side but cannot figure
out what is getting in the way here. I have trawled the MS site and
Googled like a madman but I can't even find anything that sounds remotely
like the issue I'm having. Is there an Access scientist out there who knows
what could be causing this?
Cheers
Andrew