批量打印报告 [英] Batch Printing Reports
问题描述
我需要批量打印报告。我查看过去关于批量打印的帖子，但我不知道视觉基础，所以我需要一些指导。
我有一份基于a的报告参数查询。我将它设置为从我用来预览和打印报告的表单中获取参数值。
我必须每次使用不同的值重复打印该报告。我想将其设置为批量打印，从表格中的列表中获取值。
感谢您的时间
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
推荐答案
我需要批量打印报告。我查看过去关于批量打印的帖子，但我不知道视觉基础，所以我需要一些指导。
我有一份基于a的报告参数查询。我将它设置为从我用来预览和打印报告的表单中获取参数值。
我必须每次使用不同的值重复打印该报告。我想将其设置为批量打印，从表格中的列表中获取值。
感谢您的时间
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
如果您不熟悉VBA，最简单方法
更改报表数据源，以便参数由表驱动，链接到参数表，为参数创建组并让报表在参数组上执行分页符。
参数表可以有一个是/否字段，可以用来打开和关闭参数。
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.
最简单你不熟悉VBA的方式
更改报告数据源，使参数由表驱动，链接到参数表，为参数创建一个组并生成报告在参数组上执行分页符。
参数表可以有一个是/否字段，可用于打开和关闭参数。
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.
这基本上就是我以前的方式。但我遇到了页眉和页脚的问题。对于每个报告（或组），我有一个报告标题，位于第一页的页眉上方。如何让组标题位于页眉上方？
此外，我希望页面页脚中的页码能够与每个组重新开始。我在这个网站上找到了如何做到这一点：
http： //www.mvps.org/access/reports/rpt0013.htm
我遵循了指示，但它没有奏效。也许我对控件的设置是错误的。当他说控制团体的名字时，我不确定他在谈论什么。 ctlGrpPages应该采用什么类型的控制？它应该不受约束吗？等等
这就是我所担心的地方，并认为批量打印可能更容易。任何帮助都会被贬低。
我不怕VBA，我只是崭新而且需要一些指导。
非常感谢！
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，
组头不能超过页眉。
Hello Missionary,
Group headers CANNOT come above Page Headers.
这基本上就是我以前的方式。但我遇到了页眉和页脚的问题。对于每个报告（或组），我有一个报告标题，位于第一页的页眉上方。如何让组标题位于页眉上方？
此外，我希望页面页脚中的页码能够与每个组重新开始。我在这个网站上找到了如何做到这一点：
http： //www.mvps.org/access/reports/rpt0013.htm
我遵循了指示，但它没有奏效。也许我对控件的设置是错误的。当他说控制团体的名字时，我不确定他在谈论什么。 ctlGrpPages应该采用什么类型的控制？它应该不受约束吗？等等
这就是我所担心的地方，并认为批量打印可能更容易。任何帮助都会被贬低。
我不怕VBA，我只是崭新而且需要一些指导。
非常感谢！
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!
这篇关于批量打印报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
