Solved

Events not firing in ActiveX controls on Form

Posted on 2003-10-21
6
393 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

691 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