Duane Hookom said: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
Lindad said: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?
Lindad said: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?
Duane Hookom said: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
Lindad said: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 said: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
Lindad said: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?
Duane Hookom said: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?
Lindad said: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.
Duane Hookom said: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
Lindad said: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?