Run all macro

  • Thread starter Thread starter hoachen
  • Start date Start date
H

hoachen

I have 5 small macros that contains numerious of queries for each macro. I
tried to create a new macro that run all those macro but not successful. Is
this possible to work? or what have i miss out the step and cause it not work?

example macro1 contains
query1. query2, query3, query4, q....

example macro2 contains
query1. query2, query3, query4, q....
 
Is there an error message when you try to run the new macro?

What happens? "not successful" doesn't tell us quite enough ...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Hoachen,

I agree with Jeff. In addition, what actions do you have in the new macro.
I have assumed you are using the RunMacro action, but would be good if you
could confirm.
 
Thanks all,

Yes, I am using macro. After i put all those small macro into this macro(let
call it Big macro). It does not run at all meaning didn't update anything.
Inside this Big macro, I put the name of each small macro and the action as
"RunMacro" and on the bottom of the marco name, like macro repeat and macro
expression i leave it blank. Please advise

hixxxej said:
[

hoachen said:
I have 5 small macros that contains numerious of queries for each macro. I
tried to create a new macro that run all those macro but not successful.
Is
this possible to work? or what have i miss out the step and cause it not
work?

example macro1 contains
query1. query2, query3, query4, q....

example macro2 contains
query1. query2, query3, query4, q....
Click to expand...
Click to expand...
 
Back
Top