Selected labels

[Guest]

Hi,
I have a large DB with lots of tables. One table has names and addresses.
Does anyone know of a way, without changing the tables, of selecting names
and printing labels for the selected names? Also is there a way to print
part way down the page in order to use labels forms where some of the lables
are already gone.

 

[Pat Hartman\(MVP\)]

Look up this article in the knowledge base for skipping labels:
299024 - HOW TO Skip Used Mailing Labels and Print Duplicates in Access 2002
If you use criteria such as a date range or a particular state or a
particular status, then selecting records for printing is pretty easy. If
you want to go through a list and "mark" each selected record, that is a
different problem. You could use a multi-select listbox. This article
should help with that.
135546 - How to Use a Multi-Select List Box to Filter a Form

 

[Guest]

Hi again Pat,

I thought I had my skip label routine working, but in doing more testing I
found out that my routine not only skips down of the first page but on every
page. Do you know what I missing. In order to get it to work in the first
place I had to change the
=LabelSetup to "Call LabelSetup" in my Report "On Open" code. That's the
only thing I changed.

Thanks for you help

 

[Guest]

Thanks Pat,
I'm using Access 2000. Is there an article or any other info to skip labels
for Access 2000? I looked but couldn't fine anything......
Thanks,

 

[Guest]

Hi again Pat,
Please ignore my last request. I did get the skip label routine to work. I
had to replace an equal sign with a "Call" statement. Thanks for your help,
I would never have fighred it out myself.

Thanks

 

[Pat Hartman\(MVP\)]

Glad you got it to work. There's lots of really good articles in the KB. I
usually go there first if I have a problem.