Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,

    May have asked this question before, but cannot find the reference to it.

    I have a A4 report, which is approx 12 pages long, which is given out to the general public advertising houses for sale. I would like to be able to put an advertising page (the size of a whole a4 piece of paper) in at say page 4, which would be the hole page. The report is made up of cells and twelve cells appear to one a4 page.
    Best Regards,

    Luke

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I'd create a separate report for the single-page advertisement. You can then use VBA code to
    - Print the first 3 pages of the other report.
    - Print the advertisement.
    - Print pages 4 and on of the other report.

  3. #3
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='797278' date='10-Oct-2009 21:08']I'd create a separate report for the single-page advertisement. You can then use VBA code to
    - Print the first 3 pages of the other report.
    - Print the advertisement.
    - Print pages 4 and on of the other report.[/quote]

    The problem comes, when I need 20 of these reports at any one time and the machine that prints them also staples them together neatly.
    Best Regards,

    Luke

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I'd temporarily turn off the automatic stapling, and do it manually.

    Or convert the three reports to PDF, merge them into a single PDF file and print that. But I'm not sure it's worth the effort.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •