Printing Mailing Labels

[Stanley]

I am using Avery labels and have a label report generated in Access to print
them.
I am using a 3 by 10 sheet.
The problem is my users just wants to print one label. I can print to the
first label on the page, but then I would waste the page.
Is there any way I can tell Access to print to a particular label on the
page (say the third row down and second label in?). Then they can peel off
that label and the next time they need one they can use that page again with
another label position.
Thanks,
Stanley

 

[Jeff Boyce]

Stanley

I believe you can find something like this either at mvps.org/access or by
searching on-line.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[David C. Holley]

From prior experience, don't go there. If its something where they just need
a single label they're better off going to a typewriter. The challenge with
trying to print to just one specific label is that you also have to keep in
mind that inevitably sheets of labels will be wasted because they were
inserted in the printer wrong, somebody else accidently printed a letter on
the labels, etc.

 

[JimBurke via AccessMonster.com]

This may not be the answer you're looking for, but they make label printers
for this sort of thing, where you only want to print one at a time. You could
probably do what you want using a regular label sheet and printer, but the
user will have to know which label they want to print on each time. Not so
sure that would really work.

 

[Mr. B]

Stanley,

I have a way of doing this by allowing the user to select the label that
they want to use. If there is more than one label to be printed, it will
start with the selected label and continue from there. When I developed this
for a client I also provided a calculation to tell them how many sheets they
needed to place in their printer if there were multiple labels to be printed.

I do not have this available to me at the moment, but if you will go to my
web site as shown below and send me an email, I will be happy to send you the
code.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm

 

[fredg]

I am using Avery labels and have a label report generated in Access to print
them.
I am using a 3 by 10 sheet.
The problem is my users just wants to print one label. I can print to the
first label on the page, but then I would waste the page.
Is there any way I can tell Access to print to a particular label on the
page (say the third row down and second label in?). Then they can peel off
that label and the next time they need one they can use that page again with
another label position.
Thanks,
Stanley

First create a label report.
Then add a Report Header.
Add 2 unbound controls to the Header.
Name one "SkipControl"
Leave it's control source blank.

Name the other control "SkipCounter"
Set it's control source to:
=[Skip how many?]

Then code the report's Detail Print event¡K

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

End Sub

And code the Report Header's Format event¡K

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

Run the label report. Enter the number of label positions you wish to
skip.

 

[David C. Holley]

I'd go with that route as its going to be the easiest to implement overall
with the greatest flexibility. What if you user needs to print 4 lables
instead of just 1?

 

[Daniel Pineault]

Yes it can easily be done. If you google you will find lots of examples
showing you how this can be done. Below is one link

http://books.google.ca/books?id=IDx...resnum=8&ved=0CCIQ6AEwBw#v=onepage&q=&f=false

I know they didn't invent the technique, I think I saw it in Ken Getz book
back in '97. Anyways, check it out. It should be exactly what you are
looking for.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Jeff Conrad [MSFT]]

Everything you need right here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=318

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com