473,396 Members | 2,158 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Events related errors

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
3 5430
FishVal
2,653 Expert 2GB
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
Anane
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
2,653 Expert 2GB
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

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

Similar topics

5
by: Vince C. | last post by:
Hi. I'd like to trap ADO Recordset object events in my ASP script (either VBS or JS, no preference). I've tried (in VBS) writing a Sub rs_RecordChangeComplete( adReason, cRecords, pError,...
2
by: RAJ | last post by:
In our multi-tier application, we have several ASP.NET user controls which will update the same data source provided by middle tier logic. In this particular scenario we have one user control...
18
by: Brett | last post by:
What are reasons to create your own events? Why not just call a class method/function instead? Thanks, Brett
2
by: ThunderMusic | last post by:
hi, I have 2 services running, one doing a job and the other monitoring the job is done and that the other service (the one doing the job) is still running. The thing is, the 1st service fire some...
0
by: kolalakitty | last post by:
Hopefully someone here can help me/point me in the right direction. I've found tons of references towards making relations, creating rows, saving said rows, using datagrids, databinding objects,...
1
by: Ryan | last post by:
I am trying to log events to SQL Server instead of the computers event log, but, although I get no errors, I have no luck. The webevents_events table is empty. I have a custom event that I am...
0
ADezii
by: ADezii | last post by:
Not all ADO Power Users realize that there are Events, specifically related to the Connection and Recordset Objects, for which they can write code for. If one is aware of these Events, it is not...
6
by: Charles Law | last post by:
I have a base class and derived classes that relate to a set of documents I process. e.g. DocBase, DocA, DocB, DocC. The processing of each document is handled in teh derived classes, as you might...
1
by: swethak | last post by:
Hi, I am desiging the calendar application for that purpose i used the below code. But it is for only displys calendar. And also i want to add the events to calendar. In that code displys the...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.