Run time error (2000)

Topic

New Reply

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!!!

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote

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

Reply | Quote

Thanks so much!!!

Reply | Quote