Print Access Report Twice by Default

Hi All

I have a query I hope you can help me with.  A have a Hire Agreement database, that has a front end allowing people to complete customer details etc, then print of a report which then prints onto a specific piece of stationery.  This has recently been changed by the director, and whereas in the past when you selected print it would print it of twice by default (one customer copy, one office copy) it now no longer does that.

I am not an Access guru, and this is not somethng that I would usually deal with but Im trying to help out.  Does anyone have any idea how I can re-instate the previous settings, or if not get this up and running again.

To confirm, I need to be able to click Print once, but it print off twice by default ONLYwhen running this report!!

Thanks in advance for your help

Nick
fingwongAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
hnasrConnect With a Mentor Commented:
Set the default printer.

Use the openreport starement twice.

    DoCmd.OpenReport "reportName"
    DoCmd.OpenReport "reportName"
0
 
trbazeConnect With a Mentor Commented:
Set the property for the default printer in the OnOpen event of the report.

Report.Printer.Copies = 2
0
 
fingwongAuthor Commented:
Thanks I'll give them both a whirl and let you know
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.