POP-UP FORMS

[Danielle17]

I have 4 forms--all of which are pop-up forms so that there are no toolbars present. On one of those forms I have a command button that is supposed to show the user a report. The report works just fine but it pops up behind all of the forms. Is there a way that I can have the report pop-up in front of all of the forms? I checked the properties on the report but there isn't one about being a pop up. The command button that pops up the report has some code so I thought maybe I could put something in there...but I don't know a lot of code. Please help!

 

[Rohdem]

I may be mistaken, but I don't think setting a form's pop up value to 'yes' affects any toolbars. All it does is force the form to stay on top of everything else, if you set the pop up value to 'no', your report should open on top of the form. Mike Rohde
rohdem@marshallengines.com

 

[LonnieJohnson]

If you are going to use these maximzed popup forms, you may want to consider 1) closing the unneeded forms as you open the form that you do need. 2) putting the Docmd.Minimize command just before the open report command. This will minimize your active form and show the report.

However now you will have to put a command in the reports close event to maximize the form again when the user closes it.

Not pretty but it works. ljprodev@yahoo.com
Professional Development
MS Access Applications

 

[Danielle17]

Well if I do set the forms to pop-up it does get rid of all the toolbars....but then I face the report problem...I' going to try the minimze thing and then let you know what happens...keeping my fingers crossed...one of these codes/suggestions has to work.

 

[Rohdem]

You can also get rid of the toolbars by going to
Tools--->Startup and unchecking 'allow built in toolbars' Mike Rohde
rohdem@marshallengines.com

 

[Paul7905]

Danielle,

Did you get this to work? I have the same issue currently. I can see how to minimize the popup form just before opening the report however I have been unable to figure out the syntax of the docmd to maximize the form previously minimized in the close event of the previewed form !~

thanks

Paul in Arizona

 

[rajeessh]

It is gonna somewhat cryptic code here
This will work out but this is a simple soln
Report_Open
For i = 0 to Applications.Forms.Count -1
Application.Forms(i).Visible = False
Next i

Report_NoDataFound and Report_Close

For i = 0 to Applications.Forms.Count -1
Application.Forms(i).Visible = True
Next i

This will hide and unhide the forms so that reports will come to the top
and forms order will also be maintained

 

[beeorlando]

I had the some problem and tried your code to fix it. Here's my result:

Runtime error 424

object required


What does this mean?

Thanks!