print copies

[ytakbob]

Say report form name is stdocname = PLS102
using DoCmd.OpenReport stDocName, acNormal
to print a report

I would ilke to control the number of copies from a field "label_copies" from the form that kcikc off the
openreport command...

I knew this at one time and cannot remember nor find the property that controls the number of copies to print....
Help.
Bob Schmid
bob_schmid@hmis.org
330-746-1010 ext. 1347

 

[SgtJarrow]

You will need to use the DoCmd.PrintOut method instead of the DoCmd.OpenReport....

DoCmd.PrintOut [printrange][, pagefrom, pageto][, printquality][, copies][, collatecopies] It's not important that someone else can do in one step what it took you ten to do...the important thing is that you found a solution.

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer

 

[ytakbob]

Thanks Robert
I assume Selectobject is a prereq ?

Thanks alot. It's working !

Bob Schmid
bob_schmid@hmis.org
330-746-1010 ext. 1347

 

[ytakbob]

one problem with selectobject...the command brings up the database windows to the user ??? ANy way of closing this or preventing this ? Bob Schmid
bob_schmid@hmis.org
330-746-1010 ext. 1347

 

[SgtJarrow]

I believe you only have to use something like the following....

DoCmd.OpenReport strReport
DoCmd.PrintOut acPrintAll, , , acHigh, 10

This is what I am using and it works every time....
It's not important that someone else can do in one step what it took you ten to do...the important thing is that you found a solution.

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer