Printing Mailing Labels

  • Thread starter Thread starter Emmy
  • Start date Start date
E

Emmy

Hello,
I have a report set up that prints a mail label based on
a customer code. It asks you for the customer code once
and then it shows the mail label. What I need it to do is
continue asking for customer codes. Each sheet has 30
labels on it. If I have a stack of mail, I want to be
able to go through and enter customer codes until I'm
finished with the stack. Then I need a button to cancel
so it won't keep asking. Any ideas?

Thanks so much!
Emmy
 
Hello,
I have a report set up that prints a mail label based on
a customer code. It asks you for the customer code once
and then it shows the mail label. What I need it to do is
continue asking for customer codes. Each sheet has 30
labels on it. If I have a stack of mail, I want to be
able to go through and enter customer codes until I'm
finished with the stack. Then I need a button to cancel
so it won't keep asking. Any ideas?

Thanks so much!
Emmy
Click to expand...

That's a complicated way to perform an easy task.

There are several methods to do this. Here is one.

Add a Check Box field to your table and then add the field to your
form.

Make a query with all the fields you need for the addresses. Include
the Check Box field.
On the Check Box Field's criteria line, write:
True

Make this query the report's record source.

When you wish to run the labels, place a check mark for the names you
wish to run.
Then run the report. Only those names selected will be printed. You
will not be prompted.

After printing, to then clear all the check boxes, add a command
button to your form.
Code It's click event:
CurrentDb.Execute "Update YourTableName Set
YourTableName.CheckBoxField = 0;",dbFailOnError

I hope this helps.
 
Back
Top