Run Marco, and just open the last query

  • Thread starter Thread starter Mao Monsalve
  • Start date Start date
M

Mao Monsalve

Hi

I have around 20 query, I use them for updating table ,
select query, and make table,

I want to run a macro where run the 20 queries, but I just
want the macro to open just the last query who has the
final result

the way is right now brings so many messaging windows and
open some tables, but i don't need them

Is there any way when I click run macro just open the last
query??

Thanks for your help
MAo
 
Mao,

I presume you are using OpenQuery actions in your macro. I would
recommend removing all of them that relate to Select Queries... having
them there will not achieve anything. To suppress the display of the
action query confirmation messages, put a SetWarnings/No action in the
macro before the first of the OpenQuery actions. And I would suggest
you make a form to show the "final result", and put an OpenForm action
at the end of the macro to display this.
 
Hi Steve,
thanks so much for you respond
yes I'm using open query.

I put set SetWarnings/No action to suppress the display of
the action query confirmation messages, and works perfect

I create a form an display the final result fine

about "recommend removing all the queries that relate to
Select Queries" I need them to create tables ( I use this
table to update or for mathematical purpose)before the
final table,

but I don't need this tables to open "{I use this table to
update or for mathematical purpose)" do I need to change
something else??

Thanks for you r help

Mao
 
Thanks I figure out

mao
-----Original Message-----
Hi Steve,
thanks so much for you respond
yes I'm using open query.

I put set SetWarnings/No action to suppress the display of
the action query confirmation messages, and works perfect

I create a form an display the final result fine

about "recommend removing all the queries that relate to
Select Queries" I need them to create tables ( I use this
table to update or for mathematical purpose)before the
final table,

but I don't need this tables to open "{I use this table to
update or for mathematical purpose)" do I need to change
something else??

Thanks for you r help

Mao



macro.
I would
.
Click to expand...
 
Back
Top