Changing default number of copies to print

[spencern]

Hi,
I'm investigating the purchase of a thermal label printer to use with an access app to print labels. Every time a label is printed, there needs to be 3-5 copies of the label. I'm thinking that the best way to print would be to setup a report with a single label in access and then change the number of copies in the print dialog. Is there anyway for access to set the default number of copies so I won't have to change it every time I print? Or does anyone have a better idea of how I could do this?

Thanks for the help,
Spencer

 

[KenReay]

Hi

Whi not on the the form from which you invoke the label print, have a textbox control (txtNoCopies), with default value 3 (say)

The in the command button which runs the report (label)

Dim i as Integer

For i = 1 to txtNoCopies
docmd.openreport ...etc as now
next i

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[dhookom]

I would create a table "tblNumbers" with a single numeric field "Num" and add values 1 - n (highest number required). Then add this table to your reports record source and place the Num field in the query grid. Set the criteria under the Num field to:
<=[Number to Print]
This should allow you to print multiple copies in one report.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[spencern]

Thanks I'll take a look at the database and see which solution I can fit into it.
Thanks again,
Spencer