Solved

Calling Access Event Procedures

Posted on 2011-09-19

Microsoft Access

2 solutions

223 Views

Last Modified: 2012-05-12

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

Comment

Question by:JJINFM

[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

Join The Community

6 Comments

LVL 120

Accepted Solution

by:Rey Obrero (Capricorn1)

Rey Obrero (Capricorn1) earned 250 total points

ID: 365622082011-09-19

yes!

private sub newBtn_click()
btn1_click
btn2_click

end sub

LVL 10

Assisted Solution

by:VTKegan

VTKegan earned 250 total points

ID: 365622112011-09-19

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

LVL 74

Expert Comment

by:Jeffrey Coachman

ID: 365634922011-09-19

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...

LVL 26

Expert Comment

by:Nick67

ID: 365642122011-09-19

<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

LVL 74

Expert Comment

by:Jeffrey Coachman

ID: 365642822011-09-19

Also some back ground would be nice...

<I have a form in Access that has about 2 dozen command buttons>
24 button on one form?

Why the need to do this?
What are these codes doing?

Just curious...
...in case there is a more efficient approach...

Author Closing Comment

by:JJINFM

ID: 365760642011-09-21

Thank you both.

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating an Add-to Combo Box

Article by: Helen

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.

Microsoft Access

Delivering a Word Template for Use in Merging Data from Access

Article by: Helen

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…

MS Access – Adding “Page ‘x’ of ‘y’” Over a Group in a Report

Video by: Jim

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 …

Microsoft Access

Access Desktop Databases – A Quick Tour

Video by: Jim

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.