Results 1 to 4 of 4

Access VBA Print DoCmd

This is a discussion on Access VBA Print DoCmd within the Microsoft Access forums, part of the Question Forums category; I'm a begginer at Access VBA and I'm trying to right simple code to get access to print a report ...

  1. #1
    New Member
    Join Date
    Nov 2006

    Default Access VBA Print DoCmd

    I'm a begginer at Access VBA and I'm trying to right simple code to get access to print a report to a specific network printer. Can anyone help with a simple VBA print command for hitting a network printer?

  2. #2
    MrExcel MVP Andrew Fergus's Avatar
    Join Date
    Sep 2004
    New Zealand


    Hi Stacy

    I have tested the following code over a couple of network printers and it seems to work ok. I have seen all sorts of complicated code over the internet but what I have written seems to be the simplest solution - so hopefully this works for you too.

    You need to have the other network printer installed on the your PC and you refer to the printer by its name (that you would see under the 'Printers' screen in Windows).

    I invoked this code by placing a button on a form and attaching this code to that button:

    Private Sub MyButton_Click()
    Dim defPrinter As String, NewPrinter As Printer
    'Get the default printer name
    defPrinter = Application.Printer.DeviceName
    'Create a new printer object
    Set NewPrinter = Application.Printers("MyPrinter") 'use your printer name here
    'Set the default printer to the new printer
    Set Application.Printer = NewPrinter
    'Open the report
    DoCmd.OpenReport "MyReport", acViewNormal  'use your actual report name here
    'Print the report (the next line seems to print the report and the form so I removed it, if your report doesn't print then remove the apostrophe on the next line)
    'Close the report
    DoCmd.Close acReport, "MyReport", acSaveNo  'report name again!
    'Reset the printer back to the default printer
    Set NewPrinter = Application.Printers(defPrinter)
    Set Application.Printer = NewPrinter
    HTH, Andrew
    ~ >*()))><(

    I'd rather have a full bottle in front of me than a full frontal lobotomy.

  3. #3
    New Member
    Join Date
    Nov 2006

    Default perfectly....thank you very much.

  4. #4
    New Member
    Join Date
    Jul 2010

    Default Re: Access VBA Print DoCmd

    You're great!!! I loaded your code, followed the VERY clear instructions and the code ran perfectly. Thanks so much

    My question is: I need to print a PDF file, which worked great using your code, however I would like to know how have the file/report print without prompting me for a location and file name. Can this be written into the code and have the file overwrite the existing file. Also, would need to have code that allows the enough time for the file to print before executing the rest of code.

    Thanks in advance for you help.
    Last edited by cooksc; Jul 2nd, 2010 at 03:21 PM.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts