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

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.

"Stanley" <(E-Mail Removed)> wrote in message
news:F3A2C6FC-7487-4461-9801-(E-Mail Removed)...
>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

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.

"Stanley" <(E-Mail Removed)> wrote in message
news:F3A2C6FC-7487-4461-9801-(E-Mail Removed)...
>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

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


"Stanley" wrote:

> 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

On Thu, 15 Oct 2009 11:26:01 -0700, Stanley wrote:

> 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.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

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?

"JimBurke via AccessMonster.com" <u49905@uwe> wrote in message
news:9da55b612258c@uwe...
> 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.
>
> Stanley wrote:
>>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
>
> --
> Jim Burke
>
> Message posted via http://www.accessmonster.com
>

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=IDxC...age&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.



"Stanley" wrote:

> 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

Everything you need right here:
http://www.rogersaccesslibrary.com/f...ts.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

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

"Stanley" wrote in message:
news:F3A2C6FC-7487-4461-9801-(E-Mail Removed)...

> 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