Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
    In The Footprints Of Guru Nanak- Fourth Journey In Punjab Sikh Sikhi Sikhism Dec 22, 2016
    In The Footprints Of Guru Nanak-Fourth Itinerary Sikh Sikhi Sikhism Dec 18, 2016
    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

  3. OP
    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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page