Use Specific printer

[Adam Milligan]

Hello all-

I am using Access 2007 on Windows Vista and I am trying to get a report to
print to the Primo PDF printer (istead of the default printer). I set the
option in "Page Setup"-"Page" Tab, but when I click "OK" on the dialog box,
it doesn't save. The next time I open the page setup dialog box, it is set
to "default printer" again. As I write this, I realize that I have several
subreports in this report. Do all of the subrepots have to be set to the
same printer as well? Has anyone else ever run into this? Thanks for your
time,

Adam Milligan

 

[Allen Browne]

Adam, this is a bug in Access 2007.
Microsoft has released a hotfix:
http://support.microsoft.com/kb/950488

You may be aware that MS has created a download that allows A2007 to create
PDF files:
http://www.microsoft.com/downloads/...11-3E7E-4AE6-B059-A2E79ED87041&displaylang=en

You can then create a PDF with code like this:
DoCmd.OutputTo acOutputReport, strDoc, acFormatPDF, strFile, True

 

[Michael J. Strickland]

Adam, this is a bug in Access 2007.
Microsoft has released a hotfix:
http://support.microsoft.com/kb/950488

Allen:

Have they still not fixed this?

I thought they had included the hotfix in one of the updates from
Microsoft Update.

Everyone still has to get the hot fix to set report printers?


--

 

[Allen Browne]

Yes, that's correct.

This wasn't properly fixed in SP1. No doubt many of the current hotfixes
will be in SP2, whenever that comes out.

In the mean time, the hotfixes I am aware of are listed near the top of this
page:
http://allenbrowne.com/Access2007.html