labels

[Mark R]

Could I get an overview on labels? I read some and looked
for a wizard and didn't find it.


1. How do you find the wizard on ACCESS 2000?
2. Will the label wizard work on 2 or 3 tables in a join
or should I figure a way to not do a join?

3. How do I know that the computer won't print on empty
spots?

(If a sheet of labels has for columns and whatever
(20?) rows of labels, and I printoff 7 labels, then
the sheet will be less 7 labels. The next time I run
labels, if I want to re-use that sheet so as not to
waste all those labels..........

4. I already created a report that runs off a query that
shows labeling addresses.

THE QUERY pulls
SELECT Table1.labelmailedYN table1. otherinfo
table2.name, address, city, zip, invoice date
table3.otherinfoOFpossibleinterest
From innerjoins
WHERE table1.labelmailed equal false AND
table1.maildate>forms!templateform!STARTfieldname
AND table1.maildate<forms!templateform!
ENDfieldname



THE report has textboxes for
name
address
city
zip
in the detail section

and I get a list of lables, usually 7 to 20 deep.

Is that less powerful than what the label wizard would do
for me?

 

[Jeff Boyce]

Mark

Labels are a "report", and the report wizard can help.

If you create a query that returns the records you want, you can run the
report wizard/labels wizard on that query. Go ahead and join.

As for the partial use of a sheet of labels, check the mvps.org/access
website -- I seem to recall a routine mentioned there.

Good luck

Jeff Boyce
<Access MVP>

 

[Roger Carlson]

1. The Label Wizard is in the Report Wizards section, so when you choose to
create a New Report it should give you the option.

2. The wizard won't let you create a join, but you can create a query with
the join ahead of time and use it exactly like a table.

3. Unfortunately, you have to program it to avoid blank spots. On my
website (www.rogersaccesslibrary.com) are two small Access database samples
that illustrate how to do this. They are "MultipleLabels2k.mdb" and
"MultipleLabelsOffset2k.mdb". Both of these use similar processes, but the
second one has a much more intuitive interface. You might want to start
with the first one (MultipleLabels2k.mdb), figure out how that works, then
move on to second one (MultipleLabelsOffset2k.mdb), which essentially adds
the interface stuff.

4. The only difference between a regular report and a "Label" report is
that the label report has Column information set up. You can do this
yourself by opening a report in Design View, then go to File > Page Setup.
The third tab (Columns) allows you to set up 2 or 3 columns, the row and
column spacing, how wide the columns are and how they are filled
(across-then-down or down-then-across). The only thing the Label Wizard
adds are preset values for many standard labels.


--
--Roger Carlson
www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L