By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,260 Members | 1,677 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,260 IT Pros & Developers. It's quick & easy.

Repeat printing of sections in Access 2007

P: 2
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?
Feb 23 '08 #1
Share this Question
Share on Google+
5 Replies


mshmyob
Expert 100+
P: 904
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?
Feb 24 '08 #2

P: 2
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." "Description" "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".
Feb 24 '08 #3

mshmyob
Expert 100+
P: 904
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,
Feb 26 '08 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Feb 26 '08 #5

NeoPa
Expert Mod 15k+
P: 31,768
10100 posts Mary!
I make that 20 :D
Feb 26 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.