Solved

Events not firing in ActiveX controls on Form

Posted on 2003-10-21
6
385 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

762 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now