Print Multiple copies of a report or Label from within a vba proce

[Diarmuid]

Hi, is there a simple method for printing multiple copies of a label or
report from within a VBA function.

Basically I want a user to be able to click on a print button from within a
form showing the contents of a product record and then specify how many
labels will be printed. I also need to store a default number of labels to
print with each record in the record itself.

I know it can be done by manually entering the number of copies to print
from the print dialog box, but some of these will be printed as part of a
batched scheduled print which means I also need to be able to print them
automatically.

I also need to be able to do the same thing with some reports.

Any help would be gladly received!

 

[Daniel Pineault]

Take a look at the following

http://bytes.com/answers/microsoft-access/728068-print-multiple-copies-same-report

it offers a couple solutions to your problem.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.