Batch Printing Reports

I need to batch print reports. I've looked at past posts about batch printing, but I don't know visual basic, so I'll need some coaching.

I have a report based on a parameter query. I have it set to take the parameter value from a form that I use to preview and print reports.
I have to repeatedly print that report using a different value each time. I want to set it up to batch print, taking the values from a list in a table.

Thanks for your time

Easiest way if you're not familiar with VBA

Change the report datasource so that the parameter is table driven, link to the paramater table, create a group for the parameter and have the report do a page break on the parameter group.

The parameter table could have a yes/no field that you could use to toggle the parameter on and off.

Easiest way if you're not familiar with VBA

Change the report datasource so that the parameter is table driven, link to the paramater table, create a group for the parameter and have the report do a page break on the parameter group.

The parameter table could have a yes/no field that you could use to toggle the parameter on and off.

That is basically how I had it before. But I ran into a problem with the headers and footers. For each report (or group) I have a report header that goes above the page header on the first page. How can I make the group header come above the page header?

Also, I want the page numbers in the page footer to restart with each group. I found how to do that on this site:
http://www.mvps.org/access/reports/rpt0013.htm
and I followed the directions, but it didn't work. Perhaps my settings on the controls were wrong. I'm not sure what he's talking about when he says "control name of the group" And what type of control should ctlGrpPages be? should it be unbound? etc.

So that's where I got held up and thought that batch printing might be easier. Any help would be apreciated.

I'm not afraid of VBA, I'm just brand new at it and need some coaching.

Thanks alot!

Hello Missionary,

Group headers CANNOT come above Page Headers.

That is basically how I had it before. But I ran into a problem with the headers and footers. For each report (or group) I have a report header that goes above the page header on the first page. How can I make the group header come above the page header?

Also, I want the page numbers in the page footer to restart with each group. I found how to do that on this site:
http://www.mvps.org/access/reports/rpt0013.htm
and I followed the directions, but it didn't work. Perhaps my settings on the controls were wrong. I'm not sure what he's talking about when he says "control name of the group" And what type of control should ctlGrpPages be? should it be unbound? etc.

So that's where I got held up and thought that batch printing might be easier. Any help would be apreciated.

I'm not afraid of VBA, I'm just brand new at it and need some coaching.

Thanks alot!

Hello Missionary,
Group headers CANNOT come above Page Headers.

Thanks, mshmyob; that's what I figgured. What I could do is put the "Report Heading" in the Page Header, then just turn it on and off depending on the page number. Following is the Code I mentioned for the Page numbering that I got from
http://www.mvps.org/access/reports/rpt0013.htm

I added in some lines to make the ctlText visible or invisible.
Now, I could never get the page numbers to work in the first place, so this is deffinately a stab in the dark.
Where did I go wrong in the code?
Pls keep in mind that this is my first venture into VBA and I don't know the lingo.

I have a textbox called ctlWard in the Group Header that shows the Group value.
I have an unbound textbox called ctlGrpPages that is supposed to show the page number In the page footer. Whenever I preview the Report, ctlGrpPages just shows up empty. Also, ctlText doesn't disapear.

Sorry this question is so long. I think I may be getting ahead of myself, but I'm hoping it will work.

That is basically how I had it before. But I ran into a problem with the headers and footers. For each report (or group) I have a report header that goes above the page header on the first page. How can I make the group header come above the page header?

Also, I want the page numbers in the page footer to restart with each group. I found how to do that on this site:
http://www.mvps.org/access/reports/rpt0013.htm
and I followed the directions, but it didn't work. Perhaps my settings on the controls were wrong. I'm not sure what he's talking about when he says "control name of the group" And what type of control should ctlGrpPages be? should it be unbound? etc.

So that's where I got held up and thought that batch printing might be easier. Any help would be apreciated.

I'm not afraid of VBA, I'm just brand new at it and need some coaching.

Thanks alot!

In your case I sometimes drop the report and page header/footer and use group header/footer. I even create a "dummy" column to group on in some cases to allow for a bit of creativity in the report layout.

With that being said heres some VBA. I have a table which lists all my reports by their Access name, Descriptive name, description - lstReports. I have a "Parameter" table - data in lstParam.

You can customize to loop thru and print each seperately.

You say that you have a report which is driven by a control on your form.
How about some code on your form which loops through all the items you need reports for, and, for each iteration through the loop, sets the control to the current value then opens the report. When the loop is finished all your reports should have printed off.

NB. This will not work well for viewing the results in PrintPreview mode, as each subsequent call would replace the data from the previous one.

That sounds good NeoPa, but I'm still struggling with the code.

Jaxjagfan, your post went a bit over my head. Could you explain in more basic terms. Where do I paste this code? What parts of the code do I need to change to my own table/field names, etc.


Thank you all for your help.

That sounds good NeoPa, but I'm still struggling with the code.
...

That's fine Missionary.
Put together what you can and we can fill in the gaps. We don't (shouldn't) just provide solutions, as that doesn't help you to develop your skills or understanding.

That's fine Missionary.
Put together what you can and we can fill in the gaps. We don't (shouldn't) just provide solutions, as that doesn't help you to develop your skills or understanding.

I didn't get to work on this very long as I'm going out of town this weekend, but here is what I've got so far:
I have a form with a comboBox called Wards that the query looks at to find the what records to show in the report.

Here's the code: