473,325 Members | 2,816 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Repeat printing of sections in Access 2007

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
5 2479
mshmyob
904 Expert 512MB
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
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
904 Expert 512MB
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
14,534 Expert Mod 8TB
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
32,556 Expert Mod 16PB
10100 posts Mary!
I make that 20 :D
Feb 26 '08 #6

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

Similar topics

1
by: HB2 | last post by:
I am looking have a record repeat itself in a report based on a value in the table. I want to print one label for every item I have in inventory (QtyOnHand). Thank you for any input.
3
by: Carla | last post by:
I have MS Access 2000. I converted a database from ms works and imported it. Somehow in the doing my dates got messed up. I fixed them in the table but they are still printing goofy. I have...
7
by: Jon Slaughter | last post by:
Can someone point me to some resources on how to tile an image to create a border? <td> <img src="images/MTile.png" width="1" height="30" alt=""></td> I have something like that where I need...
2
by: madval | last post by:
hi, i need your help, i'll receive some ms word documents (paragraphs, bullets, different fonts in a document -family-size-format, images, etc. a "normal" document) and i need to print them on a...
3
by: Wayne | last post by:
I'm reasonably sure that this issue isn't related to the database as such. I have an Access 2003 report with a couple of coloured logos on it that was printing fine, but now the logos only print in...
2
by: rlntemp-gng | last post by:
Re: Access 2003 My client has a printer that can print single-sided or double-sided. The default settings for this printer in Windows is double-sided printing for the bulk of their work. ...
2
XedinUnknown
by: XedinUnknown | last post by:
Hi! I am new to this forum, but not new to web design and programming. Nevertheless, I have never tried to use PNG so extensively in my pages. here's the problem. First, I have found that the...
18
by: Brett | last post by:
I have an ASP.NET page that displays work orders in a GridView. In that GridView is a checkbox column. When the user clicks a "Print" button, I create a report, using the .NET Framework printing...
1
by: pusparaj | last post by:
I had developed an application using MS Access 2003 and in my reports I have no problem whether viewing or printing it in one page from my PC or Notebook. Also no problem when I opened this...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.