Solved

Events not firing in ActiveX controls on Form

Posted on 2003-10-21
6
391 Views
Last Modified: 2010-08-05
Access 2K/Windows 2K - I have a form that holds three ActiveX controls,(MSFlexGrid).  Friday everything was working fine, but now none of the events are firing.  I have Click and DblClick events on each of the controls, but they are just not firing.  Events on native Access 2K components fire fine, as do the five Access events for the Control (OnEnter, etc).  What are not firing are the native events for the control.

Private Sub atxUnroutedCalls_DblClick()  '<- Does not fire ever (MSFlexGrid Event)
    MsgBox "atxUnroutedCalls_DblClick()"
    Call GetTripData(atxUnroutedCalls.Value)
    Call SearchForSlots
End Sub

Private Sub atxUnroutedCalls_Enter() '<- Fires Every time control is made active (access Event)
    MsgBox "Entered - atxUnroutedCalls_Enter"
End Sub

Any help would be appreciated.
0
Comment
Question by:lludden
  • 3
  • 2
6 Comments
 
LVL 11

Expert Comment

by:joekendall
ID: 9591830
Have you tried to Repair/Compact your database? I would start there first. Has any new software been added to your computer or any software updates?

Joe
0
 
LVL 18

Author Comment

by:lludden
ID: 9591921
I have done compact/repair.  The only new software (to my knowlege) was Street Atlas USA 2004.  Uninstalling it doesn't help.
0
 
LVL 11

Expert Comment

by:joekendall
ID: 9591944
If you create a new database and import the needed objects to test the Treeview, does it work then?
0
 
LVL 18

Author Comment

by:lludden
ID: 9592491
Didn't help any.  Reinstalling the OCX didn't change anything either, although if I add that control to a new form, the events fire fine.
0
 
LVL 18

Accepted Solution

by:
lludden earned 0 total points
ID: 9592583
I fixed it.

Something was corrupt on the form itself.  I created a new form, and copied all the controls and code to it, and it worked fine.  I am still not sure exactly what happened to cause the problem.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question