Solved

Events not firing in ActiveX controls on Form

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

733 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