query to generate labels

[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

 

[giorgio rancati]

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

 

[Guest]

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]

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

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]

get
a

 

[Guest]

Thanks!
I'll give it a try
Paul

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

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]

"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