By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,064 Members | 1,445 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,064 IT Pros & Developers. It's quick & easy.

How do I force MS Access to stay minimized?

P: n/a
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!

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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?
Nov 13 '05 #2

P: n/a
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!


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.