API hide access window

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PC User - 24 Mar 2007 01:22 GMT

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

Reply to this Message

storrboy - 24 Mar 2007 03:59 GMT

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).

Reply to this Message

PC User - 26 Mar 2007 00:03 GMT

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

Reply to this Message

storrboy - 26 Mar 2007 02:14 GMT

> 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....

Reply to this Message

AccessVandal - 26 Mar 2007 03:03 GMT

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.

>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
[quoted text clipped - 6 lines]
>Thanks,
>PC

Reply to this Message

PC User - 27 Mar 2007 03:16 GMT

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

Thanks,
PC

Reply to this Message