Printing of mailing labels

[Iwilfix]

I have been using a very old version of PC File.
In printing mailing labels,you are able to choose
where on the label sheet it should start printing,
as not to waste unused lables. I have not been
able to find it in access. Can anyone tell me where
or how i can find this feature.
Thanx in advance Jeff V.

 

[Arvin Meyer]

There is no feature built in to Access. Ken Getz wrote some code in the
Access Developers' Handbook which does this.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[fredg]

I have been using a very old version of PC File.
In printing mailing labels,you are able to choose
where on the label sheet it should start printing,
as not to waste unused lables. I have not been
able to find it in access. Can anyone tell me where
or how i can find this feature.
Thanx in advance Jeff V.

Jeff,
There is no built in feature in Access to do this.
However, with a bit of coding it is quite easy.

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 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 to
skip.
Then it will run the report.

 

[Iwilfix]

I have been using a very old version of PC File.
In printing mailing labels,you are able to choose
where on the label sheet it should start printing,
as not to waste unused lables. I have not been
able to find it in access. Can anyone tell me where
or how i can find this feature.
Thanx in advance Jeff V.

Jeff,
There is no built in feature in Access to do this.
However, with a bit of coding it is quite easy.

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 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 to
skip.
Then it will run the report.

Fred
Thank you for your quick response.
I will attempt your suggestion.
I have never writen code before, so this will
be a good start, as it seems simple enough for
even a newbie like myself to try
Thank you again.