Couple of Report questions

  • Thread starter Thread starter msam137
  • Start date Start date
M

msam137

1. Is there a way to get a report to preview and print landscape every
time it is ran.

2. This report has employee names and the users would like to be able
to generate multiple reports with out closing down the other report. I
am using the DoCmd to open the first report and if the user attempts
to do a report command again nothing happens. To piggy back of that
question is there a way to generate a pop up if the report was opened
and never closed.
 
Re #1:
Open the report in design view.
Open the Page Setup dialog (File menu.)
On the middle tab, set the Orientation to Landscape.
Save, and close the report.

Re #2:
Are you asking how to open multiple instances of the same report? While that
is possible (code using the New keyword), it doesn't work, because Access
confuses the different instances and applies the Filter incorrectly.
(Haven't tested in A2007, but that certainly applies to A2003 and earlier.)

You can test if Report1 is loaded like this:
CurrentProject.AllReports("Report1").IsLoaded

Here's an example of a little wrapper function for OpenReport. It closes it
if it's already open, so the new filter gets applied. It also returns
true/false to indicate if the report opened, instead of generating error
2501.
http://allenbrowne.com/AppPrintMgtCode.html#OpenTheReport
Just ignore the bit about SetupPrinter4Report (which is doing more than what
you need.)
 
Back
Top