Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print and collate report - OnClick Code

Status
Not open for further replies.

Hoving

Technical User
Apr 8, 2002
21
US
When a user presses a command button on my form, I'd like the OnClick code to print and collate 3 copies of a report. My current code prints 3 copies of the report but it does not collate them. The print and collate options work fine when I manually do it (File > Print > ...), but the -1 in the code is not collating. I also tried the code without the -1. Same thing: 3 copies but not collated.

Any other ideas?

Hoving

OnClick code:
*******************************
With DoCmd
.OpenReport "rptSurveys", acViewPreview
.SelectObject acReport, "rptSurveys"
.PrintOut , , , , 3, -1
.Close acReport, "rptSurveys"
End With
*******************************
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top