print multiple reports from one click

[Jean-Francois Gauthier]

Hi,

I have a report called contactheader.

At the header level, I have [PL] from tblcontacts, as well as other
information.

In the details I have all the subrecords from tblemployees where
tblemployees.[PL] = tblcontacts.[PL].

By using a form and link the report, I can preview or print the report as I
want it, for a particular record in tblcontacts. Lets assume PL 302B. If I
select this record on my form and click the preview report button, I get my
report as I want it. However I cannot get the report for all the records,
other then by changing record and clicking preview for that particular record.

I am trying to have a simple click that would print a report for all the
records in tblcontacts. There are about 205 records in there, therefore 205
individual reports need to be printed. Ratther then have to change record
and click 205 times to get all my reports, I would like to have some type of
code that would generate all the reports at the same time for all the records
in tblcontacts.

Basically I have tblcontacts which contain data about pay list and their
individual contacts. In tblemployees I have all the employees that have a
cheque or paystub to be delivered by the contact in tblcontact. Both tables
are connected or matched by the [PL] field, "Pay List". The report is
therefore giving me a header level view or hte paylist, and then a list of
all the employees that make part of that paylist.

Is this something that is possible to do?

Any help is greatly appreciated.

 

[Marshall Barton]

I have a report called contactheader.

At the header level, I have [PL] from tblcontacts, as well as other
information.

In the details I have all the subrecords from tblemployees where
tblemployees.[PL] = tblcontacts.[PL].

By using a form and link the report, I can preview or print the report as I
want it, for a particular record in tblcontacts. Lets assume PL 302B. If I
select this record on my form and click the preview report button, I get my
report as I want it. However I cannot get the report for all the records,
other then by changing record and clicking preview for that particular record.

I am trying to have a simple click that would print a report for all the
records in tblcontacts. There are about 205 records in there, therefore 205
individual reports need to be printed. Ratther then have to change record
and click 205 times to get all my reports, I would like to have some type of
code that would generate all the reports at the same time for all the records
in tblcontacts.

Basically I have tblcontacts which contain data about pay list and their
individual contacts. In tblemployees I have all the employees that have a
cheque or paystub to be delivered by the contact in tblcontact. Both tables
are connected or matched by the [PL] field, "Pay List". The report is
therefore giving me a header level view or hte paylist, and then a list of
all the employees that make part of that paylist.

It depends on how you are filtering the report. If the
report's record source query has a criteria for the form
control, then you're stuck.

If the report's record source is not filtered and the form
button is filtering the report by using the OpenReport
method's WhereCondition argument, then you can just add
another button that does not use the WhereCondition
argument.