Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Print multiple invoices

Discussion in 'Information Technology' started by thecuzin, Jul 28, 2006.

  1. thecuzin

    thecuzin
    Expand Collapse
    Guest

    I have an Invoice list on a form. When a invoice number is selected on the
    form you print the report which is filtered on the invoice number selected on
    the form. I do this so you can have page nubers for each clients invoice (If
    you had a report from and to invoice number the page numbers would flow over
    the diff clients and invoice numbers).
    My problem is I want to have an option to print all invoices one after
    another automaticaly. When I put a loop in a macro to do this with a stop
    macro when it gets to the last record - it tels me a macro can only run
    itself 20 times.

    Any sugestions
     
  2. Loading...

    Similar Threads Forum Date
    Footprints Of Guru Nanak In Sri Lanka History of Sikhism May 27, 2016
    Sikhism Preserving the Sikh heritage in Print Sikh Sikhi Sikhism Jan 12, 2016
    Guru Nanak's Foot-Prints in Baghdad's Sands Blogs Oct 22, 2015
    My Story Printed in Sikh Review Sept 2015 Issue Convert's Corner Oct 19, 2015
    Sakhis In The Footprints Of Guru Nanak... Redeeming Noorshah-the Magical Woman Of Kamroop History of Sikhism Mar 18, 2015

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    thecuzin wrote:
    > I have an Invoice list on a form. When a invoice number is selected
    > on the form you print the report which is filtered on the invoice
    > number selected on the form. I do this so you can have page nubers
    > for each clients invoice (If you had a report from and to invoice
    > number the page numbers would flow over the diff clients and invoice
    > numbers).
    > My problem is I want to have an option to print all invoices one after
    > another automaticaly. When I put a loop in a macro to do this with a
    > stop macro when it gets to the last record - it tels me a macro can
    > only run itself 20 times.
    >
    > Any sugestions


    Put the page number in the group footer of your report and it will reset
    for each group (Each Client).

    Good Luck

    --
    Joseph Meehan

    Dia duit
     

Share This Page