Run Marco, and just open the last query

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
 
S

Steve Schapel

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

Mao Monsalve

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
 
G

Guest

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
.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top