Solved

Access 2003 Report goes to back after closing a form

Posted on 2014-02-12
2
524 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
access pop-up form 3 31
Looking for a program that deletes all files of same size 18 59
Access 2016 - finding skipped numbers 11 22
Access 2016 7 33
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

813 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

13 Experts available now in Live!

Get 1:1 Help Now