Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Mar 2002
    Posts
    164
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Run time error (2000)

    I get the following error when I execute my macro...
    Run-time error '2202'
    you must install a printer before you design, print or preview.

    Ihave a simple macro which has a RunCode action which refers to the following module code...
    Function OutputToBudgetSummary()
    DoCmd.OutputTo acOutputReport, "Budget Summary Report", acFormatRTF, "D:ReportsBudget_Summary" & Format(Date, "yyyymmdd") & ".rtf"
    End Function

    Plus the strange thing is, it works fine on my machine, but when i try to execute this on the production server I get that message. Any ideas. I'd hate to have to install a printer to get this to work. Thanks beforehand!!!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Run time error (2000)

    Access needs to "see" a printer in order to open a report, because the formatting of a report is heavily dependent on the printer.
    But you don't need to install a physical printer; it is enough to install a printer driver in the Printers control panel.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2002
    Posts
    164
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Run time error (2000)

    Thank you so much for the reply. Could I possibly get instructions on installing a printer driver in the Printers control panel. Thanks beforehand!!

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Run time error (2000)

    The Printers control panel can be opened from the Start Menu:
    Start / Settings / Printers (or Start / Settings / Control Panel / Printers)
    Open the icon titled Add Printer
    Select the local printer option (Local or My Computer or some such text)
    Click Next
    Select a driver for a printer, preferably the same as you use on your regular PC.
    Click Next
    Don't print a sample page
    Click Finish

  5. #5
    2 Star Lounger
    Join Date
    Mar 2002
    Posts
    164
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Run time error (2000)

    Thanks so much!!!

Posting Permissions

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