Reports Printing To My Own Printer

[gracm25]

Good morning,

I've created a pretty powerful Access Database that pulls information out of some ODBC tables we have on our local server. Of course, I created the database and all the forms and reports on my work computer here. But, when I was finished, I sent that entire database out to probably 20 or 30 people in the company. On a daily basis, they run the same program from their own computer and they like to print/export/etc. the reports that are produced. However, I don't understand why those reports print our on my personal printer (the printer is on the network). If they have a default printer at their site, why wouldn't it print there? Also, I haven't included any printing macros or VBA coding. I'm tired of having 30 or 40 sheets of paper print out on my printer daily. Any suggestions?

 

[Moniker]

I'm not sure why it would direct everything to your printer, but for now, have the users use the drop-down menus (File -> Print, or Ctrl-P), where they will be prompted for a printer. If they click on the printer icon in the toolbar, they don't get the option to select a printer and it's sending it your way. You could also just remove that toolbar or at least remove the printer icon from the reports page, whereby they'd be forced to use the drop-down or keyboard shortcut.

You aren't the first person to have this problem, and I've never had this problem, but I do remember that there was a solution to it somewhere. Time to start digging (maybe in the reports section of this forum).

 

[rainman89]

do you have code to set it to default?

Dim strDefaultPrinter As String
    strDefaultPrinter = Application.Printer.DeviceName
    Set Application.Printer = Application.Printers(strDefaultPrinter)

 

[gracm25]

Hey Everyone,

Yes, I am an idiot. I received a post from another site about this topic. Apparently, I had changed the default printer setting in the "Page Setup" for each report. Instead of listing as print to default printer, I asked the reports to print to a specific printer. I did this because we were having printer troubles onsite while I was building this program and I was printing to specific printers. I guess when you change the default printer settings in the original database and send out that database to several people, your settings go with it. They don't go default to that person's computer's printer settings. So, if your printer is on the network, get ready to burn some printer paper.