Address Labels

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

Guest

I am attempting to create a report in Aceess using the Label Wizard. What my question is, is it possible to create a full page of the same label in the Label Wizard with multiple names and addresses in my Table??? If anyone could help, it would be greatly appreciated!
 
I am attempting to create a report in Aceess using the Label Wizard.
What my question is, is it possible to create a full page of the
same label in the Label Wizard with multiple names and addresses in
my Table??? If anyone could help, it would be greatly appreciated!
Click to expand...

Nelson,
Not using the wizard.
This will permit you to enter the number of times to repeat the
labels, as well as skip missing label positions on an already used
sheet.

First make sure your label report properly prints 1 label per record.

Then add a Report Header to the label report.
Add 3 unbound text boxes to the header.
1) Set the Control Source to:
= [Skip how many]
Name this control SkipCounter
2) Leave the second control unbound.
Name this control SkipControl
3) Set the third control's Control Source to:
=[Repeat how many]
Name it RepeatCounter

Next code the Report Header OnFormat event:

Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As
Integer)
[SkipControl] = "Skip"
Cancel = True
End Sub
=======
Now code the Detail OnPrint Event:
(Note that intMyPrint is Static!!)

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Static intMyPrint As Integer
If PrintCount <= [SkipCounter] And [SkipControl] = "Skip" Then
Me.NextRecord = False
Me.PrintSection = False
intMyPrint = 0
Else
[SkipControl] = "No"
Me.PrintSection = True
Me.NextRecord = True
intMyPrint = intMyPrint + 1
If IsNull([RepeatCounter]) Then
ElseIf intMyPrint Mod [RepeatCounter] = 0 Then
Me.NextRecord = True
intMyPrint = 0
Else
Me.NextRecord = False
End If
End If

End Sub
=========

When you run the report, it will ask how many labels to skip, then how
many times to repeat each label.

Hope this has helped.
 
-----Original Message-----
I am attempting to create a report in Aceess using the
Click to expand...
Label Wizard. What my question is, is it possible to
create a full page of the same label in the Label Wizard
with multiple names and addresses in my Table??? If
anyone could help, it would be greatly appreciated!
.
When you choose label wizard in new reports, select the
Click to expand...
table that your data is coming from in the drop down box.
Select the product manufacturer of the labels you are
using, then select the product number. Next select font
and font size. Next select the fields for each line of
the label. You do this by selecting a field and then
clicking on the arrow. Click enter to move down to next
line. Next determine by which fields you would like them
sorted. You are finished, name your report for future use.
 
Back
Top