How do I force MS Access to stay minimized?

[michael]

Hi, folks - I am trying to build a macro that Outputs a query to Excel,
then Auto Starts the Excel doc to show the query results.

I'd like Excel to be the top window when this is done, but my macro
always restores MS Access to the front when it finishes, hiding the new
Excel doc. I've tried ending my macro with "MinimizeApp", but it simply
minimizes Access... then immediately restores it again, covering Excel.

Is there a way to force MS Access to stay minimized at the end of my
macro, so that the Excel doc remains on top until the user chooses to
select Access again manually?

Thanks in advance for your help!

[Deano]

michael wrote:

Hi, folks - I am trying to build a macro that Outputs a query to
Excel, then Auto Starts the Excel doc to show the query results.

I'd like Excel to be the top window when this is done, but my macro
always restores MS Access to the front when it finishes, hiding the
new Excel doc. I've tried ending my macro with "MinimizeApp", but it
simply minimizes Access... then immediately restores it again,
covering Excel.

Is there a way to force MS Access to stay minimized at the end of my
macro, so that the Excel doc remains on top until the user chooses to
select Access again manually?

Thanks in advance for your help!

Not sure as this is not something I have done, but could you write a macro
that selected a cell in the workbook, or something similar, that means the
window gets selected and is thus displayed on top?

[Craig Alexander Morrison]

Why not use Excel to get the data from the database?

See the Excel menu : Data, Import External Data.

Just design a query that gives you the data you want from the database and
then select it for importing.

--
Slainte

Craig Alexander Morrison
"michael" <mp********@sbcglobal.net> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

Hi, folks - I am trying to build a macro that Outputs a query to Excel,
then Auto Starts the Excel doc to show the query results.

I'd like Excel to be the top window when this is done, but my macro
always restores MS Access to the front when it finishes, hiding the new
Excel doc. I've tried ending my macro with "MinimizeApp", but it simply
minimizes Access... then immediately restores it again, covering Excel.

Is there a way to force MS Access to stay minimized at the end of my
macro, so that the Excel doc remains on top until the user chooses to
select Access again manually?

Thanks in advance for your help!