multiple reports - same parameters

  • Thread starter Thread starter sandie
  • Start date Start date
S

sandie

I have a linked database with a series of reports that
run weekly. There are similar parameter's in each query
that I would like to fill in once for the entire series
of reports. I can't change the tables in the database.
Any help is appreciated.
 
I have a linked database with a series of reports that
run weekly. There are similar parameter's in each query
that I would like to fill in once for the entire series
of reports. I can't change the tables in the database.
Any help is appreciated.
Click to expand...

If you use a parameter Query referencing an unbound Form for the
criteria, e.g.

=[Forms]![frmCriteria]![controlname]

and run the reports from either a Macro or (better) from VBA code, you
should be able to launch all the reports without reentering the
critera. I'd put a button on frmCriteria to launch the reports.
 
To keep it basic (as your questions is vague), you could
make a form with some unbound text boxes that will hold
the parameters for the reports. I assume that the reports
run from queries, if that is the case you could set the
critera to look at two text boxes. One could be the
beginning date and the other the ending date. if each of
the different reports has different formats that would use
the above same critera you would then make a button that
ran all of the reports using the critera you make from
these text boxes. You make the button do something like
this...

Dim stDocName As String
Dim stDocName2 As String
Dim stDocName3 As String


stDocName = "YourFirstReport"
stDocName2 = "YourSecondRpt"
stDocName3 = "Your3rdRpt"

DoCmd.OpenReport stDocName, acNormal
DoCmd.OpenReport stDocName2, acNormal
DoCmd.OpenReport stDocName3, acNormal

So what that would do is print each report based on the
critera in the query which looks that the text boxes on
the form.

If that doesn't help add a follow up post here and I will
see what I can do to help
 
Back
Top