Repeat printing of sections in Access 2007

[jbbooey]

While printing reports in Access 2007, how can I print a section in a report over and over (looping) multiple times using VBA or a macro?

[mshmyob]

Not to sure what you are asking.

Do you mean on the 1st page you want the Report Header, Page Header, Page footer to be printed once. But on all other pages only say the Detail section printed?

Give a little more detail of how you want the report to appear because I can't even see why you would need this feature (but you never know). If you explain exactly what you want maybe then we can find the solution.

cheers,

While printing reports in Access 2007, how can I print a section in a report over and over (looping) multiple times using VBA or a macro?

[jbbooey]

I was way too vague. Sorry!

This application utilizes a report that will be used for data gathering in a manufacturing cell. I need a specific section of the report to be printed, and re-printed, based on a value in one of the fields of the report. This particular section contains both a group header and the detail section. Example:


Group: "Job No." "Job Decription" "Parts"
Detail: "Step No." "Descriptio n" "Time" "Status"

I need this information to repeat (while printing) based on the value contained in "Parts". This will give me a duplicate printing for every occurrence of "Parts".

[mshmyob]

I'm still having trouble understanding your requirement. My first instinct is that the answer is NO but I have requested some additional help from the other 'experts' online.

I will wait for their response, they may be able to come up with a dfinitive YES or NO.

cheers,

[MMcCarthy]

I think the problem here is the issue of grouping.

My understanding is you need to group by job number and then to group by Parts.

You can put the controls for "Job No.", "Job Decription" and "Parts" in the Parts grouping and make the Job No group invisible. I think this will give you what you want.

[NeoPa]

10100 posts Mary!
I make that 20 :D