Form Retrieval Question

[missymarie1014]

This is Access 2000. I have an application with over 200 forms. I created an onscreen calculator as an Access form and I want to provide the user with the ability to call up the calculator with the double click action from within any form in the application. I've tested the form and now I am wondering is there a way to have this form open when I double click in the body of any form in the application without having to program the Form Double Click event in each and every form, some sort of global routine which applies to all form objects? Thanks for any help!

 

[MajP]

If you want to double click on the form, then you will have to write a click event on the form. You could use vba extensibility. In other words you could write code to write the code. It would probably be a lot easier to add to the menu bar or a short cut bar.

 

[missymarie1014]

When you say "you could write code to write the code", do you mean that I could write some code to insert my tested code into the Dbl_Click event of every form automatically. Can you tell me a little about that? Could I also instruct the code to ignore the procedure if the Dbl_Click event already has any code in it? This is the only routine that is running in this event anywhere. Then I could run the code at any time and it would only update forms where the Dbl_Click event has no code. Thanks for responding!

 

[MajP]

Here is a good link on vba extensibility

http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=307

Yes you could write could to insert a double click event into every form module without a double click event.

I still think I would go with a menu choice.