query to generate labels

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a simple form to print a special label and a table with a field that
contains the number of labels needed for each specific item. How do I get a
record for each label needed so that they can all be printed at once.
Paul
 
Paul LeBlanc said:
I have a simple form to print a special label and a table with a field that
contains the number of labels needed for each specific item. How do I get a
record for each label needed so that they can all be printed at once.
Paul
Click to expand...
 
Giorgio,
That looks good however I do want to go to the next record and each batch
has a different number of labels that is contained in the field [LblQty]
 
Hi Paul,

It is the same concept
----
Option Explicit
Dim intNumberRepeats As Integer

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)

intPrintCounter = intPrintCounter + 1
If intPrintCounter < Me![LblQty] Then
' Do not advance to the next record.
Me.NextRecord = False
Else
' Reset intPrintCounter and advance to next record.
intPrintCounter = 0
End If

End Sub
----

Bye
Giorgio

Paul LeBlanc said:
Giorgio,
That looks good however I do want to go to the next record and each batch
has a different number of labels that is contained in the field [LblQty]

giorgio rancati said:
get
a
Click to expand...
Click to expand...
 
Thanks!
I'll give it a try
Paul

giorgio rancati said:
Hi Paul,

It is the same concept
----
Option Explicit
Dim intNumberRepeats As Integer

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)

intPrintCounter = intPrintCounter + 1
If intPrintCounter < Me![LblQty] Then
' Do not advance to the next record.
Me.NextRecord = False
Else
' Reset intPrintCounter and advance to next record.
intPrintCounter = 0
End If

End Sub
----

Bye
Giorgio

Paul LeBlanc said:
Giorgio,
That looks good however I do want to go to the next record and each batch
has a different number of labels that is contained in the field [LblQty]

giorgio rancati said:
"Paul LeBlanc" <[email protected]> ha scritto nel
messaggio I have a simple form to print a special label and a table with a field
that
contains the number of labels needed for each specific item. How do I get
a
record for each label needed so that they can all be printed at once.
Paul
Click to expand...
Click to expand...
Click to expand...
 
Back
Top