A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Report preview behind form



 
 
Thread Tools Display Modes
  #1  
Old August 18th, 2007, 03:16 AM posted to microsoft.public.access.reports
Steve S
external usenet poster
 
Posts: 162
Default Report preview behind form

I have a regular with a button to preview a report. The report always opens
behind the form. The form is set up as pop-up and modal so the user can't
see any toolbars or menus. How can I force the report preview to appear in
front of the form? Thanks in advance.
--
Steve S
  #2  
Old August 18th, 2007, 03:18 AM posted to microsoft.public.access.reports
Steve S
external usenet poster
 
Posts: 162
Default Report preview behind form


--
Steve S
Let's try this again...
I have a regular form with a button to preview a report. The report always
opens
behind the form. The form is set up as pop-up and modal so the user can't
see any toolbars or menus. How can I force the report preview to appear in
front of the form? Thanks in advance.
--
Steve S


"Steve S" wrote:

I have a regular with a button to preview a report. The report always opens
behind the form. The form is set up as pop-up and modal so the user can't
see any toolbars or menus. How can I force the report preview to appear in
front of the form? Thanks in advance.
--
Steve S

  #3  
Old August 18th, 2007, 04:21 AM posted to microsoft.public.access.reports
fredg
external usenet poster
 
Posts: 4,386
Default Report preview behind form

On Fri, 17 Aug 2007 19:18:06 -0700, Steve S wrote:

The usual method is to make the pop-up form Not Visible,
Me.Visible = False
then either close it or make it Visible again in the Report's Close
event.

Either:
DoCmd.Close acForm, "FormName"
or
Forms!FormName.Visible = True

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
  #4  
Old August 19th, 2007, 03:32 AM posted to microsoft.public.access.reports
Bob Howard
external usenet poster
 
Posts: 71
Default Report preview behind form

I do the same.

I define the report as popup, but not modal, with a control box and close
button,and "both enabled" for min/max. Then in the form, I simply execute a
docmd.maximize after the openreport. I don't mess with visible or anything
like that.

I have lots more to really make this work for me --- write offline and I'll
give you some additional stuff... Basically, I've put a modal popup form in
between my "real" form and the report ... I open it as a dialog ... it opens
the report. I do this so that the user cannot minimize the preview window
and gain access to the form that started it all (because the form is locked
up --- since it has a modal popup dialog on the screen).

bob

"Steve S" wrote in message
...
I have a regular with a button to preview a report. The report always
opens
behind the form. The form is set up as pop-up and modal so the user can't
see any toolbars or menus. How can I force the report preview to appear
in
front of the form? Thanks in advance.
--
Steve S



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:35 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.