By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,490 Members | 1,796 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,490 IT Pros & Developers. It's quick & easy.

Events related errors

P: 9
I get following error when i press a command button.
The expression click you entered as the event property setting produced the following error: method or data member not found.

It gives me error on clicking button, entering some data in text box etc..

When I try to declare events for button control : it has got only following events --
1. on enter
2. on exit
3. on get focus
4. on lost focus
5. on updated
It should have most important event "on click"....but it is missing

I am using Microsoft Forms 2.0 command button, i.e. i dont use button available in MS-Access. I go to more controls and I select Microsoft Forms 2.0 controls.

Application was working, but it suddenly started giving these errors.

Kindly help me out.


Some additional info about these errors:::::
When i press SHOW HELP >>, it displays following message::

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.
Oct 7 '08 #1
Share this Question
Share on Google+
3 Replies


FishVal
Expert 2.5K+
P: 2,653
Hi, Anane.

Obviously reference to "Microsoft Forms 2.0" library is broken.
Check it in VBE Tools->References and reestablish.
If you are not sure there the library could reside but still have MSForms.CommandButton control in "More controls..." menu, you may put it on a form and Access will establish reference automatically.

Regards,
Fish
Oct 7 '08 #2

P: 9
Hi, Anane.

Obviously reference to "Microsoft Forms 2.0" library is broken.
Check it in VBE Tools->References and reestablish.
If you are not sure there the library could reside but still have MSForms.CommandButton control in "More controls..." menu, you may put it on a form and Access will establish reference automatically.

Regards,
Fish


I tried to insert a new button on form.....even though it is not showing "ON CLICK" event in property window of button.

Also, i tried to remove "microsoft form 2.0 object library" and link it freshly, it is saying "can't remove control or reference; in use"
Oct 7 '08 #3

FishVal
Expert 2.5K+
P: 2,653
I tried to insert a new button on form.....even though it is not showing "ON CLICK" event in property window of button.
Yes it is no availbale in Form design Properties window - Access displays only Control object events, no ActiveX events. But it is available in VBE window.

Also, i tried to remove "microsoft form 2.0 object library" and link it freshly, it is saying "can't remove control or reference; in use"
Are all objects saved and closed and mdb itself is not locked?
Oct 7 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.