Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.
Course Of The Month
3 days, 4 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
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
Active 4 days ago
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
On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear? Sometimes you may have an additional problem: where the devil did they go? If you last had a popup form open…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents. The steps to find the Templates folder path are …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another.
Base the dependent combo on a query for its row source:
Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…
Suggested Courses
Course of the Month3 days, 4 hours left to enroll
752 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.