Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
Solved
Calling Access Event Procedures
Posted on 2011-09-19
Hi Experts.
I have a form in Access that has about 2 dozen command buttons that each have an event procedure to run when clicked. I would like to add one more button that would run the all the event procedures from all the buttons. Is there a way to call these other 'on click' button events from the new button?
Thanks in advance.
JJ
I have a form in Access that has about 2 dozen command buttons that each have an event procedure to run when clicked. I would like to add one more button that would run the all the event procedures from all the buttons. Is there a way to call these other 'on click' button events from the new button?
Thanks in advance.
JJ
[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
2
- +2
6 Comments
You can just simply call the btnAction1_OnClick() event in the code of the all button like below
Private Sub btnActionAll_Click()
btnAction1_Click()
btnAction2_Click()
etc...
End Sub
Private Sub btnActionAll_Click()
btnAction1_Click()
btnAction2_Click()
etc...
End Sub
You had better make sure you have some iron-clad error handling and/or rollback functionality in place...
In case one of the subs fails...
In case one of the subs fails...
<You had better make sure you have some iron-clad error handling and/or rollback functionality in place...
In case one of the subs fails...
>
True dat!
Even if your individual buttons have error handling, one of them failing may not bomb your mega-call, and if there are dependencies between these actions that could be bad
Copying and pasting the code from each button into a new procedure, with error handling might be prudent.
Building one big procedure that the 20 buttons call, passing in a parameter, that has a Select Case structure to deal with the piecemeal or mega-press might also be good.
But yes, they can all be called together like the first two posters have written
In case one of the subs fails...
>
True dat!
Even if your individual buttons have error handling, one of them failing may not bomb your mega-call, and if there are dependencies between these actions that could be bad
Copying and pasting the code from each button into a new procedure, with error handling might be prudent.
Building one big procedure that the 20 buttons call, passing in a parameter, that has a Select Case structure to deal with the piecemeal or mega-press might also be good.
But yes, they can all be called together like the first two posters have written
Featured Post
Veeam is happy to provide a free NFR license for one year. It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.
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
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
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 …
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.
Suggested Courses
Course of the Month9 days, 14 hours left to enroll
722 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.