Full page of the same label?

[Guest]

I have no difficulty with producing single labels or a full sheet of lables
for various 'tagged' contacts. However, is it possible to produce a full
page of the same label when using Access, as you can when using Word?

 

[Duane Hookom]

If a full page of the same label is 30 labels, create a table with 30
records and add it to the record source of your report with no join lines. I
generally prefer to create a table of numbers "tblNums" with a single,
numeric field "Num" and add values 1 through 1000 (or whatever). You can
then add this table to your report's record source and set the criterian
under the [Num] field to:
<=30

 

[Guest]

OK... but I have a table with 100+ miscellaneous contacts. Sometimes I need
a label for all of them (which is fine), sometimes for several of them (which
is also fine) but I frequently need a whole sheet of labels printed for just
one person. I tag that name, have a query set up for tagged people, and a
label report is then run for those (or that) tagged entry.

In Word I can choose 'single label print' (and then which available label on
the sheet I want to print to) or 'full sheet of the same label'. In access
it only seems to print a single label (or as many as I have tagged) always
starting from the top left hand label.

At the moment, if I want a full sheet of labels for one individual stored on
an Access table, I retype their details in word and then use the label
tool... but I can't believe their isn't an equivalent way of printing a page
of labels directly from Access?

If a full page of the same label is 30 labels, create a table with 30
records and add it to the record source of your report with no join lines. I
generally prefer to create a table of numbers "tblNums" with a single,
numeric field "Num" and add values 1 through 1000 (or whatever). You can
then add this table to your report's record source and set the criterian
under the [Num] field to:
<=30
--
Duane Hookom
MS Access MVP

I have no difficulty with producing single labels or a full sheet of lables
for various 'tagged' contacts. However, is it possible to produce a full
page of the same label when using Access, as you can when using Word?

 

[Duane Hookom]

How far did you get with my described solution? In about the time it took
you to reply, I could have created the table as described and performed the
other steps as suggested. If it didn't work, I would come back with a
description of the results and why they aren't what was expected.
--
Duane Hookom
MS Access MVP

OK... but I have a table with 100+ miscellaneous contacts. Sometimes I
need
a label for all of them (which is fine), sometimes for several of them
(which
is also fine) but I frequently need a whole sheet of labels printed for
just
one person. I tag that name, have a query set up for tagged people, and a
label report is then run for those (or that) tagged entry.

In Word I can choose 'single label print' (and then which available label
on
the sheet I want to print to) or 'full sheet of the same label'. In
access
it only seems to print a single label (or as many as I have tagged) always
starting from the top left hand label.

At the moment, if I want a full sheet of labels for one individual stored
on
an Access table, I retype their details in word and then use the label
tool... but I can't believe their isn't an equivalent way of printing a
page
of labels directly from Access?

If a full page of the same label is 30 labels, create a table with 30
records and add it to the record source of your report with no join
lines. I
generally prefer to create a table of numbers "tblNums" with a single,
numeric field "Num" and add values 1 through 1000 (or whatever). You can
then add this table to your report's record source and set the criterian
under the [Num] field to:
<=30
--
Duane Hookom
MS Access MVP

I have no difficulty with producing single labels or a full sheet of
lables
for various 'tagged' contacts. However, is it possible to produce a
full
page of the same label when using Access, as you can when using Word?

 

[Guest]

Sorry of I appear to be being particularly dense... but I don't understand
why I need to create another table? I already have the data source - I just
want to print it.

However, I think you have answered my question. It appears it isn't
possible to simply click on an option in Access as you can in Word.

How far did you get with my described solution? In about the time it took
you to reply, I could have created the table as described and performed the
other steps as suggested. If it didn't work, I would come back with a
description of the results and why they aren't what was expected.
--
Duane Hookom
MS Access MVP

OK... but I have a table with 100+ miscellaneous contacts. Sometimes I
need
a label for all of them (which is fine), sometimes for several of them
(which
is also fine) but I frequently need a whole sheet of labels printed for
just
one person. I tag that name, have a query set up for tagged people, and a
label report is then run for those (or that) tagged entry.

In Word I can choose 'single label print' (and then which available label
on
the sheet I want to print to) or 'full sheet of the same label'. In
access
it only seems to print a single label (or as many as I have tagged) always
starting from the top left hand label.

At the moment, if I want a full sheet of labels for one individual stored
on
an Access table, I retype their details in word and then use the label
tool... but I can't believe their isn't an equivalent way of printing a
page
of labels directly from Access?

If a full page of the same label is 30 labels, create a table with 30
records and add it to the record source of your report with no join
lines. I
generally prefer to create a table of numbers "tblNums" with a single,
numeric field "Num" and add values 1 through 1000 (or whatever). You can
then add this table to your report's record source and set the criterian
under the [Num] field to:
<=30
--
Duane Hookom
MS Access MVP

I have no difficulty with producing single labels or a full sheet of
lables
for various 'tagged' contacts. However, is it possible to produce a
full
page of the same label when using Access, as you can when using Word?

 

[Duane Hookom]

I should have first stated there is no similar functionality in Access label
reports. The easiest solution is what I have suggested. There are other code
based solutions that I feel are more complex.

--
Duane Hookom
MS Access MVP

Sorry of I appear to be being particularly dense... but I don't understand
why I need to create another table? I already have the data source - I
just
want to print it.

However, I think you have answered my question. It appears it isn't
possible to simply click on an option in Access as you can in Word.

How far did you get with my described solution? In about the time it took
you to reply, I could have created the table as described and performed
the
other steps as suggested. If it didn't work, I would come back with a
description of the results and why they aren't what was expected.
--
Duane Hookom
MS Access MVP

OK... but I have a table with 100+ miscellaneous contacts. Sometimes I
need
a label for all of them (which is fine), sometimes for several of them
(which
is also fine) but I frequently need a whole sheet of labels printed for
just
one person. I tag that name, have a query set up for tagged people,
and a
label report is then run for those (or that) tagged entry.

In Word I can choose 'single label print' (and then which available
label
on
the sheet I want to print to) or 'full sheet of the same label'. In
access
it only seems to print a single label (or as many as I have tagged)
always
starting from the top left hand label.

At the moment, if I want a full sheet of labels for one individual
stored
on
an Access table, I retype their details in word and then use the label
tool... but I can't believe their isn't an equivalent way of printing a
page
of labels directly from Access?

:

If a full page of the same label is 30 labels, create a table with 30
records and add it to the record source of your report with no join
lines. I
generally prefer to create a table of numbers "tblNums" with a single,
numeric field "Num" and add values 1 through 1000 (or whatever). You
can
then add this table to your report's record source and set the
criterian
under the [Num] field to:
<=30
--
Duane Hookom
MS Access MVP

I have no difficulty with producing single labels or a full sheet of
lables
for various 'tagged' contacts. However, is it possible to produce a
full
page of the same label when using Access, as you can when using
Word?