473,382 Members | 1,377 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

Printing labels from Access

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
6 8581
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: DBQueen | last post by:
I have a database which will be printing out labels for SMALL test tubes (1/4" high). We have yet to find a reasonably-priced printer (labelwriter) which can effectively print this on ROLLS of...
3
by: Grim Reaper | last post by:
I print mailing labels out of Access 2000 databases about 3 to 4 times a week. I have been having problems with one thing since I have been printing mailing labels. I print mailing labels by...
3
by: ChadDiesel | last post by:
I've been posting questions here the last week, but if you don't know my situation: I have a "Print Labels" button on the subform that sends the appropriate box information on the subform to a...
4
by: Arif | last post by:
I C# code prints very slow as compared to a third party barcode printing software. That software prints approximately 10 labels in 2 seconds while my C# code prints 10 labels in 5 to 6 seconds. And...
3
by: Mika M | last post by:
Hi all! I have made an application for printing simple barcode labels using PrintDocument object, and it's working fine. Barcode printer that I use is attached to the computer, and this...
6
by: MJ | last post by:
Is it possible to print varying numbers of labels from Access?
4
by: Wayne | last post by:
I have a simple database of addresses each with unique key and the user is able to create a table of selected keys and how many labels they need for each. The print program, using label counting...
11
by: fieldling | last post by:
I have a query which I view through a form. Due to problems with the label wizard printing to a dot-matrix printer I have some code to print out a single label when a command button is clicked. This...
5
by: Ron | last post by:
Hi All, I've got a report that prints mailing labels. It utilizes a routine that asks the number of labels to skip, the number of each label to print, and then prints. It works really well on...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.