By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,472 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Printing labels from Access

P: n/a
Ron
Hi,

I know Access allows for easy construction of a report setup to print labels
from a table/query, etc. I've done that one. It works pretty well for what
I need.

However, is there an example anywhere that someone can point me to that is
more flexible?

And, I mean flexible in this regard:

Let's say I need to print labels for 3 people in my files, and I want 3
identical labels for each. So, I've got a routine that picks out the people
and I'm ready to go. I put a sheet of labels into the printer (33 labels on
each sheet Avery 5160--3 columns of labels with 10 rows). I print what I
need. All is right with the world.

5 minutes later, I discover I need another set of 3 (or, possible 4 or
whatever) labels for a different set of 3 people. Not a problem...my
routine works fine and I can pick out the 3 (or however many) people and
again, I'm ready to print.

Here's the problem! The sheet of labels in the printer has the first 15
labels already gone. I used them already. How do I tell my printing
routine to START printing on the 16th label? Is there a utility somewhere
that can do that? Someone know of a routine I can plug in? I've got one
idea for printing labels where I'll need to print 1-3 labels each time a new
client is added. Will I then have to waist the unused remainder of labels
on each of these sheets?????

No, it wouldn't be easier to wait until I've got a bunch (like, 33) to
print. Different people printing different labels for different reasons.
Also, some of these labels will be different colors.

So far, I'm stumped!

Anyone have a solution?
ron
Jul 19 '06 #1
Share this Question
Share on Google+
6 Replies


P: n/a

P: n/a
Sorry if I missed it but I could not see an answer to the issue that
Ron was having difficulty with

pi********@hotmail.com wrote:
straight from MS site:
http://www.microsoft.com/downloads/d...displaylang=en
Jul 19 '06 #3

P: n/a
On Wed, 19 Jul 2006 03:17:48 GMT, Ron wrote:
Hi,

I know Access allows for easy construction of a report setup to print labels
from a table/query, etc. I've done that one. It works pretty well for what
I need.

However, is there an example anywhere that someone can point me to that is
more flexible?

And, I mean flexible in this regard:

Let's say I need to print labels for 3 people in my files, and I want 3
identical labels for each. So, I've got a routine that picks out the people
and I'm ready to go. I put a sheet of labels into the printer (33 labels on
each sheet Avery 5160--3 columns of labels with 10 rows). I print what I
need. All is right with the world.

5 minutes later, I discover I need another set of 3 (or, possible 4 or
whatever) labels for a different set of 3 people. Not a problem...my
routine works fine and I can pick out the 3 (or however many) people and
again, I'm ready to print.

Here's the problem! The sheet of labels in the printer has the first 15
labels already gone. I used them already. How do I tell my printing
routine to START printing on the 16th label? Is there a utility somewhere
that can do that? Someone know of a routine I can plug in? I've got one
idea for printing labels where I'll need to print 1-3 labels each time a new
client is added. Will I then have to waist the unused remainder of labels
on each of these sheets?????

No, it wouldn't be easier to wait until I've got a bunch (like, 33) to
print. Different people printing different labels for different reasons.
Also, some of these labels will be different colors.

So far, I'm stumped!

Anyone have a solution?
ron
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
Please respond only to this newsgroup.
I do not reply to personal e-mail
Jul 19 '06 #4

P: n/a
Ron

<pi********@hotmail.comwrote in message
news:11*********************@75g2000cwc.googlegrou ps.com...
straight from MS site:
http://www.microsoft.com/downloads/d...displaylang=en
That link is actually for the forms examples, but there's a link on that
page for the report examples and I downloaded that. I've now modified it
the way I need and it's running beautifully.

Thanks much! Both for your knowledge, and the time you spend sharing it
here.
ron
Jul 19 '06 #5

P: n/a
Ron
"Nick 'The Database Guy'" <ni*****@btinternet.comwrote in message
news:11**********************@i42g2000cwa.googlegr oups.com...
Sorry if I missed it but I could not see an answer to the issue that
Ron was having difficulty with

pi********@hotmail.com wrote:
>straight from MS site:
http://www.microsoft.com/downloads/d...displaylang=en
Hi Nick,

You've gotta search for it. I looked around and found that link referred to
the forms examples at that particular site. Further down the page was what
"other downloads" are (or, some such) and saw the report examples there. I
downloaded said examples from that link and sure enough, there's something
like 15 or so example reports that do all kinds of things. Quite cool.
Check it out. There's also query examples at another link. A WEALTH of
info and examples.

I've now modified the label example by changing field names, where it gets
data, filters, etc and stuck it where I needed it and it's working like a
champ!

Plus, I've now got all the other examples to check out and learn from!

Hang in
ron
Jul 19 '06 #6

P: n/a
Ron
"fredg" <fg******@example.invalidwrote in message
news:qy****************************@40tude.net...
On Wed, 19 Jul 2006 03:17:48 GMT, Ron wrote:
>Hi,

I know Access allows for easy construction of a report setup to print
labels
from a table/query, etc. I've done that one. It works pretty well for
what
I need.

However, is there an example anywhere that someone can point me to that
is
more flexible?

And, I mean flexible in this regard:

Let's say I need to print labels for 3 people in my files, and I want 3
identical labels for each. So, I've got a routine that picks out the
people
and I'm ready to go. I put a sheet of labels into the printer (33 labels
on
each sheet Avery 5160--3 columns of labels with 10 rows). I print what I
need. All is right with the world.

5 minutes later, I discover I need another set of 3 (or, possible 4 or
whatever) labels for a different set of 3 people. Not a problem...my
routine works fine and I can pick out the 3 (or however many) people and
again, I'm ready to print.

Here's the problem! The sheet of labels in the printer has the first 15
labels already gone. I used them already. How do I tell my printing
routine to START printing on the 16th label? Is there a utility
somewhere
that can do that? Someone know of a routine I can plug in? I've got
one
idea for printing labels where I'll need to print 1-3 labels each time a
new
client is added. Will I then have to waist the unused remainder of
labels
on each of these sheets?????

No, it wouldn't be easier to wait until I've got a bunch (like, 33) to
print. Different people printing different labels for different reasons.
Also, some of these labels will be different colors.

So far, I'm stumped!

Anyone have a solution?
ron

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

Thanks for your response. I think I've got my problem solved via the
suggestion by pi********@hotmail.com. I'll check your suggestion out when I
get a chance and see which I like more. You just weren't fast enough!
::grin::

Thanks, once again, for your time and knowledge you so generously share with
the NG,
ron
Jul 19 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.