Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.
Calling Access Event Procedures
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
Who is Participating?
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
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
-
Course of the Month8 days, 14 hours left to enrollMonitoring and Operating a Private Cloud with System Center 2012 R2 273 lessons
private sub newBtn_click()
btn1_click
btn2_click
end sub