Label printout

[Guest]

I printout labels on a HP laser printer. The labels are Avery no. 5766
8-1/2"x11" sheets with 30 labels per page (2 columns).

When I run a batch of labels I'm always left with labels on a page. I want
to be able to start my next printout from that first left over label.

How do I identify this label and how do I start my printout from that label
using a command button?

 

[fredg]

I printout labels on a HP laser printer. The labels are Avery no. 5766
8-1/2"x11" sheets with 30 labels per page (2 columns).

When I run a batch of labels I'm always left with labels on a page. I want
to be able to start my next printout from that first left over label.

How do I identify this label and how do I start my printout from that label
using a command button?

First make sure your label report is properly printing a full sheet of
labels.

Then add a Report Header to your label report.
Add 2 text boxes to the Header.
1) Name one SkipControl
Leave it's control source unbound

2) Name the other SkipCounter
Set it's control Source to =[Skip How Many?]

Now code the Report Header Format event as below:

Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As
Integer)
[SkipControl] = "Skip"
Cancel = True
End Sub
==========

Next code the Detail OnPrint event:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
If PrintCount <= [SkipCounter] And [SkipControl] = "Skip" Then
Me.NextRecord = False
Me.PrintSection = False
Else
[SkipControl] = "No"
Me.PrintSection = True
Me.NextRecord = True
End If

End Sub
=====

When you are ready to run the label report, it will ask how many label
positions to skip.
Then it will run the report.

 

[RD]

I printout labels on a HP laser printer. The labels are Avery no. 5766
8-1/2"x11" sheets with 30 labels per page (2 columns).

When I run a batch of labels I'm always left with labels on a page. I want
to be able to start my next printout from that first left over label.

How do I identify this label and how do I start my printout from that label
using a command button?

I use this:
http://www.peterssoftware.com/ls.htm

HTH,
RD