I am using Access 2007 and I am trying to setup my report to print to a specific printer ( setup\page\use specific printer). But after I close and save the report, it goes back to the default printer. Why is this happening? I've never had this problem when I used Access 2003. I made sure that the designated printer is online and I successfully printed a test page. Please advise. Thank you
A:
This link should help you out
http://www.mvps.org/access/reports/rpt0009.htm
You will have to set the printer to the one you want using VBA or it will just default back
Kevin Ross
2010-09-02 07:11:41
The whole printer thing was updated in the 2003 version. The link applies to the 2000 version.
Remou
2010-09-02 07:29:24
The PrintDevMode code should still work, but interacting with the printer device (actually introduced in A2002, not A2003) is substantially easier (though in my opinion, still not as easy as it ought to be).
David-W-Fenton
2010-09-02 19:01:59
the hot fix didnt work. please advise
Nathaniel_613
2010-09-08 05:18:58
+1
A:
Apparently this is a lingering bug: http://allenbrowne.com/Access2007.html#Bug
There is a hotfix: http://support.microsoft.com/kb/950488
Remou
2010-09-02 07:28:27