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 copies that vary by value in Qty field, with running totals

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

  1. Lele

    Expand Collapse

    I need to print work tickets for our production people that reflect the
    number of items to be produced and help us track that we have produced and
    shipped all items on the order.
    For example if my order is for 3 pillows and 2 bedskirts, I need to produce
    5 work tickets. I have been using this great code written by Graham Mandeno
    and it works super. (see Below). I would like to refined the code as follows:

    First: I would like the 3 pillow tickets to show 1 of 3, 2 of 3, and 3 of 3.
    Of course the 2 bedskirts would show 1 of 2, 2 of 2 etc. for each item on
    the order.

    Second: I would also like to have each of the 5 tickets say 1 of 5 items on
    the order, 2 of 5 items on the order, etc. (this way the shipper is more
    likely not to miss a piece on the order.)

    Third, I produce draperies either as single panels or in pairs. If the UOM
    on the work order is pairs I need 2 copies of the work ticket produced for
    each pair - one for left and one for the right.



    Dim iCopiesPrinted As Integer

    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    If FormatCount = 1 Then iCopiesPrinted = 0
    iCopiesPrinted = iCopiesPrinted + 1
    If iCopiesPrinted < QTY Then Me.NextRecord = False
    End Sub

    Private Sub Report_Page()
    iCopiesPrinted = iCopiesPrinted - 1
    End Sub

  2. Loading...

    Similar Threads Forum Date
    Is there any reason only one gurdwara prints official copies of Sri Guru Granth Sahib Sikh Sikhi Sikhism Aug 21, 2009
    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

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