Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 391
  • Last Modified:

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
0
fingwong
Asked:
fingwong
2 Solutions
 
hnasrCommented:
Set the default printer.

Use the openreport starement twice.

    DoCmd.OpenReport "reportName"
    DoCmd.OpenReport "reportName"
0
 
trbazeCommented:
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

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now