Printing PLEASE HELP

[Sillyboy11]

okay hello,

i have set up a form with buttons to a report one being a preview of the report and one being a print button for the report. i would find it helpful if anyone would know how to set a default of printing the report out twice i have already tryed a macro which dosent work it only prints out the form! does anyone know any VBA programming for this ive tried loads of book?

Ps: the report also has a paramter value set so could this be the problem?? as i only want one record to be printed out?

Thanks!

 

[RickSpr]

All you want is for the Print button to print two copies of the report, right? You should be able to do that by simply executing OpenReport twice.

If for some reason you need to do this from the actual report, as if you'd set Copies to 2 in the printer properties, you have to do this in the Report_Open event, using the PrtMips property. PrtMips is not like typical Access properties, though. It's actually a byte array, which you can't process directly. The help file contains an example of how to use it, but it will take some careful work to adapt it to your needs. Rick Sprague

 

[RickSpr]

Oops! That should be the PrtDevMode property. Both PrtDevMode and PrtMip (not "PrtMips"--another mistake) are byte arrays that give access to printer properties, but PrtDevMode is the one that contains the number of copies. Rick Sprague