API hide access window

[PC User]

I have a question about using the API hide access window module. This
works ok for my forms, but the report preview window always gets
hidden or shows up behind the form. How can I use this module and have
the preview reports in front of the form? I use the code from the
website "The Access Web " to show only the active form, but is
cumbersome to figure out how to effectively do a report preview and
return to the previous form.

Thanks,
PC

 

[storrboy]

I haven't tried this so I'm guessing.
Have you tried setting the report's Pop-Up property to True?
Near as I can tell in order for the main window to be hidden there
must be a pop-up form visible. This means that the form is supposed to
stay on top of other forms (windows). If the report were a pop-up as
well, it should open in front of the last window (form or other db
object).

 

[PC User]

I have Access 2000 which doesn't have PopUp properties for reports.
Is there another solution or can I create a PopUp property for all
reports?

Thanks,
PC

 

[storrboy]

I have Access 2000 which doesn't have PopUp properties for reports.
Is there another solution or can I create a PopUp property for all
reports?

Thanks,
PC

You can't make an intrinsic property like that.
Have you tried minimizing the active form first?

Screen.ActiveForm.SetFocus
DoCmd.Minimize
DoCmd.OpenReport....

 

[AccessVandal via AccessMonster.com]

Hi,

You can only maximized the report, however, if the Form is set to PopUp
= True and is Maximized, your report will always go behind the form.

Try the Report’s OnOpen event to hide the popup form. Like…

Forms!YourFormName.Visible = False

Than, in the report’s OnClose event,

Forms!YourFormName.Visible = True.

 

[PC User]

Thanks for your reply. I tried your suggestion, but I haven't gotten
it to work properly. Have you tested this method?

Thanks,
PC