Solved

Access 2003 Report goes to back after closing a form

Posted on 2014-02-12
2
513 Views
Last Modified: 2014-02-13
I have an access 2003 database with a form and a sub form.  on the subform there is a button that runs a macro.  The macro opens a floating form that has several buttons on them to run specific reports, also via macros. These reports are all run from the same query, but different filters on each report. The reports pop up in a print preview.

So User clicks on button on sub form. New free floating report menu form pops up with several buttons. Print this building, print that building, etc . . .

Whatever report they choose displays in a print preview fine. The free floating report menu form is still there.  If I close the free floating report menu form, it appears to close the report behind it as well. but it actually pushes the report back behind everything else. it's still open but the user cant see it.  Then, if they clcik on the same specific button again it doesn't do anything because that report is already open.

I want to do the following.

Open form. Click on this report menu button on subform.  click on one of the reports on the free floating report menu form, have the report open up and the free floating menu close automatically.  OR have it stay up in foreground and have user close it. That;s fine too.just as log as the report stays on top when its done.

Hope I make sense.
0
Comment
Question by:MrSlithy
2 Comments
 
LVL 4

Accepted Solution

by:
Jack Leach earned 500 total points
ID: 39855042
Open the report preview in Dialog mode... that'll keep them from doing anything else while it's open.  That sounds like the easiest way to get to one of your desired behaviors.

I'm not sure the Macro syntax for it offhand (don't use them much, prefer VBA), but I'd guess it'll be fairly self explanatory.

hth
0
 
LVL 2

Author Closing Comment

by:MrSlithy
ID: 39857584
That did the trick. Exactly what I needed. Thanks!
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now