M Michael Kintner Jan 18, 2004 #1 How can I tell a report to print 5 copies? VB Code Please.... Thank you in advance for any help... (smile) Mike
How can I tell a report to print 5 copies? VB Code Please.... Thank you in advance for any help... (smile) Mike
F fredg Jan 18, 2004 #2 How can I tell a report to print 5 copies? VB Code Please.... Thank you in advance for any help... (smile) Mike Click to expand... From a command button on a form? Code the command button click event: DoCmd.SelectObject acReport, "rptName", True DoCmd.PrintOut , , , ,5 If the report is already open in Preview mode, change True to False. If you wish to have the user enter the number of copies each time, then use an unbound control on the form. Change the PrintOut to: DoCmd.PrintOut, , , , Me!ControlName
How can I tell a report to print 5 copies? VB Code Please.... Thank you in advance for any help... (smile) Mike Click to expand... From a command button on a form? Code the command button click event: DoCmd.SelectObject acReport, "rptName", True DoCmd.PrintOut , , , ,5 If the report is already open in Preview mode, change True to False. If you wish to have the user enter the number of copies each time, then use an unbound control on the form. Change the PrintOut to: DoCmd.PrintOut, , , , Me!ControlName
