Other people's reports printing on my printer

[Monroeski]

I have a network printer set up right near my office. Throughout the day, reports from a database I created keep popping out from a bunch of different services. It appears that the default printer for the report is this nearby printer (which is what I have set as the default printer on my own computer). I did some testing on nearby computers under other people's accounts, and what is apparently happening is this -

When you load up the database, the default printer is whatever your default printer normally would be. As soon as you hit the button to open the report, though, the default printer is set to this local network printer. Here is my code for opening the report -

Private Sub cmd_EquipmentReport_Click()
On Error GoTo Err_cmd_EquipmentReport_Click
 
    Dim stDocName As String
 
    stDocName = "rpt_Equipment"
    DoCmd.OpenReport stDocName, acPreview
 
Exit_cmd_EquipmentReport_Click:
    Exit Sub
 
Err_cmd_EquipmentReport_Click:
    MsgBox Err.DESCRIPTION
    Resume Exit_cmd_EquipmentReport_Click
 
End Sub

I don't see anything there that would change the default printer on a different computer, under a different user account, to my own personal default printer. I also can't find anything in the report properties that would be causing it to do this. Any ideas on what could be causing this?

[nico5038]

You can set the printer for a report by opening the report in design mode and select the wanted paper setting and printer using File/Pagesettings and File/Print. Saving the report will use these settings the next time you print it.
However, when you "move" the .mdb to another PC these settings will be reset, unless you have placed the .mdb on a server.

When using Access 2003 you can manage this easy from code by using some sample code from the Access Cookbook (http://www.oreilly.com/catalog/accesscook2/ see CDROM and the index)

The older versions are very hard to change....

Nic;o)