This question is very similatr to the the problem stated in:
I have a program that people use on various PCs. The actual printers will be network printers but vary depending on what department the person is working in . If I set the report's "Use Specific Printer" to be the same as the default printer no problem. But if I tell the report to use the default printer, it doesn't work. It won't display in print preview. If I go to design view and hit the preview button. The report temporarily goes away and rather than the Previewed report showing up, it goes right back to design view. Based on the related thread above, I tried putting in the following code in the report's On Open event using the defailt printer mode:
10 PreviousPrinter = Application.Printer.Device
20 Application.Printer = Application.Printers("HP LaserJet 4000 Series PCL 5 on COOLSERV1")
30 Application.Printer = Application.Printers(Previ
But it failed to work on line 20. Run Time Error 5. Invalid procedure call or argument"
Spent many hours on this so far and stumped.
Have to go to bed now, 12:16 AM EST, but will check this thread first thing in the morning.