Solved: Access Report Printing

[candie213]

I would like to make a access report default to print 2 copies whenever it prints. I created a POS system and would like it to print 2 receipts when a sale is complete.

[CreganTur]

How are you telling Access to print your report currently?

[candie213]

I created a buttom in a form to pull up the receipt(Report) to print.

[CreganTur]

Use the DoCmd.PrintOut method to print your report- it has a parameter for Copies where you an designate the number of copies you want printed.

HTH:thumb

[candie213]

Use the DoCmd.PrintOut method to print your report- it has a parameter for Copies where you an designate the number of copies you want printed.

HTH:thumb

Yes, I understand that is the function to do it with. I just don't know how to write the code to make it happen.

This is what I have so far and it is not working.

Private Sub cmdPrintCash_Click()
'Open report in Preview mode
DoCmd.OpenReport "CashInvoice", acViewPreview
'Print out specified number of report copies
DoCmd.PrintOut , , , , 2
End Sub

I added this code to the report. Should it be a module instead?

[CreganTur]

That code looks correct. What happens when you click the button to run this code?

[candie213]

That code looks correct. What happens when you click the button to run this code?

It only prints one copy.

[OBP]

candie, do you still need to do this?

[candie213]

candie, do you still need to do this?

No, I got it to work. Thanks!

[CreganTur]

Mind sharing your solution so others can benefit?

[candie213]

Thanks for every ones help. Below is the code I used to get it to work....

Private Sub cmdPrintCash_Click()
'Open report in Preview mode
DoCmd.OpenReport "CashInvoice", acViewPreview
'Print out specified number of report copies
DoCmd.PrintOut , , , , 2
End Sub