Results 1 to 4 of 4
  1. #1
    philandre is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2016
    Posts
    4

    Urgent Help ( Printing Reports in Document Range )

    Dear Access Programmers,

    I would like to ask your support for the code below.


    My point here is i want to print multiple records that having sub form details.

    Voucher # 0001 with Sub Form Details ( Total Pages is 2 )
    Voucher # 0002 with Sub Form Details ( Total Pages is 5 )

    Now i want to print it by document range from Voucher # 0001 to 0002 but the problem is when i am printing it shown page 1 to 7 and i don't need it.

    I need when i print in document range, the page N of N will count only as per Voucher ID/#.
    Voucher # 0001 page 1 to 2 , page 2 to 2


    Voucher # 0002 page 1 to 5, 2 to 5 and so on.

    Appreciate your fast reply in this regard.

  2. #2
    kagoodwin13 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Feb 2012
    Posts
    181
    Create another form, that has both Voucher #0001 and Voucher #0002 as subforms.

    Then use a VBA script similar to this to define print range: https://stackoverflow.com/questions/...ain-pages-only

  3. #3
    philandre is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2016
    Posts
    4
    Dear Mr. Kagood,

    Thank you for your prompt reply.

    Actually, i dont want to print it in different2x file names.

    I just need to print multiple documents in one time but the pages should count only page N to N as per Voucher #/ID.

    My concerned here is the pages in report footer..

    When you print preview Voucher # from 0001 to 0002 range... it should shown like this each pages

    Voucher # 0001 in report footer page 1 of 2 then next page Voucher # 0001 page 2 of 2 then next page Voucher# 0002 page 1 to 5, then next page Voucher # 0002 page 2 to 5 and so on.

    But when printing it shown page 1 to 7 ,, it counts all pages for all Vouchers.

    I hope you got my point.

  4. #4
    philandre is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2016
    Posts
    4

    Please find attached and see the pages it counts all. for the two order ID

    Dear Access Programmer,

    Please find attached for your kind advise and help..

    Order ID 11076 has one page
    Order ID 11077 has two pages

    but when you select all order ID # 11076, 11077 it shown page 1 to 3 ..????

    I dont want to print one by one by order ID. I want to print it in multiple but the page footer should appear the page N of N as per order ID...

    appreciate your kind help in this regard.
    Attached Files Attached Files

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Printing a Range of Invoices (Reports)
    By ManuelLavesa in forum Programming
    Replies: 4
    Last Post: 09-15-2015, 03:16 PM
  2. Replies: 3
    Last Post: 04-16-2014, 04:29 PM
  3. Help printing off multiple reports.
    By MelonFuel in forum Forms
    Replies: 5
    Last Post: 06-29-2012, 12:25 PM
  4. Printing reports off a list box
    By kbandong1 in forum Reports
    Replies: 3
    Last Post: 03-05-2011, 09:51 PM
  5. Printing Reports....
    By Danny Christie in forum Reports
    Replies: 1
    Last Post: 12-06-2006, 05:51 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums