Selecting from which label to print a report

[Guest]

I have a report which is formatted into 8 labels per page. Is there a way I
can tell Access which labels to print?

Peter De Baets (http://www.peterssoftware.com) has a free utility called
LabelSaver, which allows you to select the position of the first label on the
first page you will print. But it assumes you are going to print the whole
database.

What I need is a way - if possible - to tell Access to start printing from
label number "X".

 

[Allen Browne]

One approach:
Skip Used Mailing Labels and Print Duplicates
at:
http://support.microsoft.com/kb/231801/en-us

Note that the 'Print Duplicates' logic is flawed in that article, but the
skip labels should work unless you skip more than 8 labels (i.e. your whole
sheet.)

An alternative approach would be to use a UNION query to give you blank
labels to start with. This involves creating a table named (say) tblCount,
with one Number field named CountID, and 7 records numbered 1 to 7. Then
type up a UNION query that combines the statement from your existing query
with a statement that gives you the blank labels.

Something like this:
SELECT False AS BlankLabel, Orders.OrderID, Orders.CustName
FROM Orders
UNION ALL
SELECT True AS BlankLabel, Null AS OrderID, Null AS CustName
FROM tblCount
WHERE tblCount.CountID <= [HowManyBlanks];

Then in your report, you will need to sort on the BlankLabel field first to
ensure the blank labels are printed before the others.

 

[Guest]

Thanks for your reply, Allen.

These procedures still assume the whole database is going to be printed...
I'm dealing with a database that, by the end of each year, reaches around
6,000 records, so printing the whole stuff is not a feasible choice. I need
only to print around 30 labels every day, and it would be nice if I could
position them so as to match the used label sheets.

Cheers

Matt Vilhena

One approach:
Skip Used Mailing Labels and Print Duplicates
at:
http://support.microsoft.com/kb/231801/en-us

Note that the 'Print Duplicates' logic is flawed in that article, but the
skip labels should work unless you skip more than 8 labels (i.e. your whole
sheet.)

An alternative approach would be to use a UNION query to give you blank
labels to start with. This involves creating a table named (say) tblCount,
with one Number field named CountID, and 7 records numbered 1 to 7. Then
type up a UNION query that combines the statement from your existing query
with a statement that gives you the blank labels.

Something like this:
SELECT False AS BlankLabel, Orders.OrderID, Orders.CustName
FROM Orders
UNION ALL
SELECT True AS BlankLabel, Null AS OrderID, Null AS CustName
FROM tblCount
WHERE tblCount.CountID <= [HowManyBlanks];

Then in your report, you will need to sort on the BlankLabel field first to
ensure the blank labels are printed before the others.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a report which is formatted into 8 labels per page. Is there a way I
can tell Access which labels to print?

Peter De Baets (http://www.peterssoftware.com) has a free utility called
LabelSaver, which allows you to select the position of the first label on
the
first page you will print. But it assumes you are going to print the whole
database.

What I need is a way - if possible - to tell Access to start printing from
label number "X".

 

[Allen Browne]

So you want to add other criteria to your query as well, so that it prints
just certain records?

That's just a matter of working out your criteria, and entering it into the
Criteria row in query design, or as the WhereCondition argument for
OpenReport.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thanks for your reply, Allen.

These procedures still assume the whole database is going to be printed...
I'm dealing with a database that, by the end of each year, reaches around
6,000 records, so printing the whole stuff is not a feasible choice. I
need
only to print around 30 labels every day, and it would be nice if I could
position them so as to match the used label sheets.

Cheers

Matt Vilhena

One approach:
Skip Used Mailing Labels and Print Duplicates
at:
http://support.microsoft.com/kb/231801/en-us

Note that the 'Print Duplicates' logic is flawed in that article, but the
skip labels should work unless you skip more than 8 labels (i.e. your
whole
sheet.)

An alternative approach would be to use a UNION query to give you blank
labels to start with. This involves creating a table named (say)
tblCount,
with one Number field named CountID, and 7 records numbered 1 to 7. Then
type up a UNION query that combines the statement from your existing
query
with a statement that gives you the blank labels.

Something like this:
SELECT False AS BlankLabel, Orders.OrderID, Orders.CustName
FROM Orders
UNION ALL
SELECT True AS BlankLabel, Null AS OrderID, Null AS CustName
FROM tblCount
WHERE tblCount.CountID <= [HowManyBlanks];

Then in your report, you will need to sort on the BlankLabel field first
to
ensure the blank labels are printed before the others.

I have a report which is formatted into 8 labels per page. Is there a
way I
can tell Access which labels to print?

Peter De Baets (http://www.peterssoftware.com) has a free utility
called
LabelSaver, which allows you to select the position of the first label
on
the
first page you will print. But it assumes you are going to print the
whole
database.

What I need is a way - if possible - to tell Access to start printing
from
label number "X".