Results 1 to 6 of 6
  1. #1
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    313

    Prompting for a Printer without Printing Report

    I know I can use DoCmd.RunCommand acCmdPrint to prompt for a printer before printing a report, but I would like to prompt for a printer and just save the selected printer. Then I want to print the report 2 or more times to the selected printer without re-prompting for the printer between reports. Any suggestions would be appreciated.

  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,930
    The print dialog has option to indicate number of copies.

    I don't know any way to save the printer ID selected by the print dialog.

    Only alternatives I can imagine don't involve the print dialog.
    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
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    There may be a way to do this without involving the printer dialog at all have you tried using something like this:

    http://msdn.microsoft.com/en-us/libr...ice.10%29.aspx

    where you should be able to retrieve a list of all printers (I didn't try the code)

    then set your number of copies by having a text box with a value and just cycling through your print function by the number represented in that text box.

  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,930
    I have used that code. It's what I was alluding to in my previous post.

    The DoCmd.PrintOut method has an argument for number of copies.
    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
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    FWIW

    I have not tried the report properties before but, this example of application.printer demonstrates how to grab the default printer, change the printer temporarily, and then return the original default.
    https://www.accessforums.net/reports...tml#post206023

  6. #6
    EddieN1 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    313
    ItsMe, thanks, that worked.

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

Similar Threads

  1. Replies: 1
    Last Post: 03-08-2013, 03:05 PM
  2. Replies: 0
    Last Post: 01-09-2013, 10:52 AM
  3. Setting Printer when Printing Report
    By russ0670 in forum Reports
    Replies: 3
    Last Post: 05-12-2010, 09:45 AM
  4. Printing to an intermec printer from access
    By dkalsow in forum Programming
    Replies: 3
    Last Post: 12-16-2009, 06:11 PM
  5. Replies: 3
    Last Post: 10-19-2009, 01:14 PM

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