Results 1 to 5 of 5
  1. #1
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    727

    print multiple copies

    All, using access 2010. I have this code to print 2 copies of a report. but it gives me a save as popup. I don't want to save it; just print it?

    Code:
    'Open report in Preview mode
        DoCmd.OpenReport "rptCurrentfile", acViewPreview
    'Print out specified number of report copies
        DoCmd.PrintOut , , , , 2
    Please let me know what Im doing wrong.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Don't see anything wrong. It works for me.

    What is your default printer? Could it be a PDF driver?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    slimjen is offline Expert
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    727
    It works with some of my reports with the same recordsource but when printing others the save dialog pops up. I looked at the properties on each report and they are the same????

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Sorry, can't replicate issue. Try rebuilding the report.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    You have overlooked something in your Report settings.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 02-04-2014, 04:33 PM
  2. Replies: 5
    Last Post: 11-03-2011, 08:53 PM
  3. labeling multiple copies
    By tgavin in forum Reports
    Replies: 1
    Last Post: 05-11-2011, 05:07 PM
  4. Can docmd.openreport print X copies on Y printer?
    By Coolpapabell in forum Reports
    Replies: 1
    Last Post: 09-02-2009, 08:35 AM
  5. Printing multiple copies of a mailing label
    By Flight Planner in forum Reports
    Replies: 1
    Last Post: 10-19-2006, 08:16 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums