Solved

Events not firing in ActiveX controls on Form

Posted on 2003-10-21
6
387 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

785 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