VB Code for print copies

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello.. I need the ability to print three copies of a report from a form command button with a different identifying text in each header ("Office Copy", "Shipping Copy", "Purchasing Copy"). Can someone help me with this?
 
I suspect you could use something similar to what is used to print multiple
copies of a label.

http://support.microsoft.com/default.aspx?kbid=299024

In the code where you count the number of copies you've made before moving
on to the next label, you would set the value of the header you mentioned.
When you reach 3, you would start over with the next record (if printing
more than one). This code actually goes in the report and you could "hard
code" it for 3 copies so that you always get the 3 you need.

--
Wayne Morgan
MS Access MVP


EdS said:
Hello.. I need the ability to print three copies of a report from a form
Click to expand...
command button with a different identifying text in each header ("Office
Copy", "Shipping Copy", "Purchasing Copy"). Can someone help me with this?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Syntax for number of copies to print? 1
Report copies issue 8
Multiple copies of Report 5
Access Sorting and grouping using multiple tables 0
Button Coding 1
Print report based on form selection 2
Copy form datasheet to table 4

Back
Top