How do I make a window open in front of others?

[Guest]

-- Hoping there is a simple fix ... running a database in access 2000 where
multiple windows can be open at any time. At end of day a report must be run
and it is set to gp to print preview so that it can be reviewed before
sending to the printer. All works well except that the print preview screen
is always in the background behind any other windows that may be open, and
the user then must minimize each open window to review the the reoprt. Is
there a way for the print preview screen to open on top of any open windows
so that it is immediately viewable. Any suggestions would be appreciated.
Thanks!

kah

 

[Albert D. Kallal]

If you just open the report, then it will appear on top of all other windows

the two exceptions are:

The report is *already* open, but not visible (I had this bug in my
software for years, until I figured this one - making sure the report is not
*already* open, this was fixed.


The 2nd reason (and most common reason) is that your forms were accident set
as popup forms (really not needed). the forms can be set as modal, and as
mentioned, and report launched will appear on top (assuming issue #1 above
is dealt with).

So, check your forms, and if they are popup, then that setting should be
removed.

if it is the first reason, then make sure the reprot is closed when your
code launchs it.