Closing Query in Macro

  • Thread starter Thread starter Gerrym
  • Start date Start date
G

Gerrym

I have a Macro which opens four queries, when it is
finished it leaves the last query open on screen. I would
like it to close the last query and return to the access
screen (the screen from where I run the macro)
Can anyone advise pls.
 
Gerry,

It is difficult to imagine what you are doing. Generally the only
reason to "open" a query in a macro is if it is an Action Query (e.g.
Append, Update). But is sounds like yours is a Select Query if you end
up with a query datasheet displayed. So, what is the purpose of opening
the query in the macro. To me, either you want it open so you can "do"
something with it, in which case you wouldn't want it to close. Or else
you don't want it open, so therefore why open it in the first place?
 

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

Similar Threads

Compact & Repair, Open table, close table, then run macro 3
hiding queries behind a macro 2
Macro Question 1
macros with a macro 1
Closedatabase macro action pops up "Getting Started" screen 1
Pause Macro Then Resume 2
Macro works when open, but when double clicked closes database?! 3
User input to continue running the macro 4

Back
Top