Printing Reports Casewise

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I do psychological research and I use Access 2003 reports to automatically
fill in fields for each person participating (ie I print out questionnaires
as reports with the person's name, ID#, and other person-specific fields
filled in).

I know that I can print out a report for some specific cases (ie a report
"x" for cases "1-9"). Is there a way that I can print out all the reports for
a single case (ie reports "x,y, and z" for case "1")?

Thanks for your help
 
If you always want to print the same combination of Reports, you can
create a master Report that does nothing except calling your selected
Reports as subreports (this works much the same way as subforms).
Ofterwise you will have to create a Form with a multiselect listbox to
choose the reports you want (and an appropriate Control to choose the
person) and print them from VBA code fired by a button on the form.

Hello,

I do psychological research and I use Access 2003 reports to automatically
fill in fields for each person participating (ie I print out questionnaires
as reports with the person's name, ID#, and other person-specific fields
filled in).

I know that I can print out a report for some specific cases (ie a report
"x" for cases "1-9"). Is there a way that I can print out all the reports for
a single case (ie reports "x,y, and z" for case "1")?

Thanks for your help
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
It is the RecordSource of the Report that determines the specific records.
You can alter that to match the information that a user has entered on a
Form, with VBA code in the Report's Open event; alternatively, you can add a
WhereCondition argument to the DoCmd.OpenReport statement that is generated
by the Control Wizard when you create a Command Button to open the Report.

You'll need minimal VBA skills. If you don't have that, it is possible that
you can post enough details here that someone can help you with the code.

Larry Linson
Microsoft Access MVP
 
Back
Top