I've searched the forums for an answer to this question and surpassingly didn't find an answer ...

Some time ago I set up my Access 2002 DVD database to print covers on a color laser printer, though this printer is NOT the default system printer. I use the simple print command:

DoCmd.OpenReport stDocName, acNormal, , "[DVDID] = " & [DVDID]

The default system printer is the HP 1000, but this command prints the report page fine on the Magicolor 2200.

All was fine until the Magicolor prints no more …. So now I need to change Access to print the report on a different printer (Still not the default HP 1000). How do I do that?

File>PrintSetUp

Thanks for the hint ... on Access 2002, It's File/Page Setup where one can choose a specific printer (or the default).

............ but that didn't help. Despite pointing to the Canon printer, it still prints the report on the Magicolor 2200..... !!!!!

Mike,

perhaps as a 80% or temporary solution: try to display the printer dialog box; so the user can select the correct printer.

Search for "Printer Dialog Box".

As I think the best solution for the Box is (found it while searching, so don't ask why/how it works ;-):

DoCmd.SelectObject acReport, stDocName, True
DoCmd.RunCommand acCmdPrint
DoCmd.Close acReport, stDocName


HTH,
Barbarossa II