My VB Application opens an Access Report and has an option to generate the
report in PDF once the report is closed. This is accomplished by:
- Switching over to the Acrobat Printer ( i.e. PDFWriter ) from the default
printer.
- Setting a string type sub key ( PDFFilename ) in the registry
HKEY_CURRENT_USER\Software\Adobe\Acrobat PDFWriter ) to store the PDF in
a user selected directory with a filename that's determined by VB codes.
- Generate the PDF by issuing the command ".DoCmd.OpenReport sReport,
acViewNormal".
- Closing the report by issuing the command ".DoCmd.Close acReport,
ReportName, acSaveNo".
- Resetting to the default printer from Acrobat Printer "PDFWriter".
This works fine with Acrobat 5.0. When I recently installed Acrobat 6.0, I
managed to set the directory and name of the PDF into a string type sub key
( PDFFilename ) in the registry (HKEY_CURRENT_USER\Software\Adobe\Acrobat
PDFMaker). However, I ran into a host of problems:
- It does not recognize the filename in the string type sub key
"PDFFilename" in the registry. Instead, it uses its own default filename to
save the PDF.
- It does not recognize the user selected directory in the string type sub
key "PDFFilename" in the registry. Instead, it saves the PDF in the "My
Documents" directory even though I left the "Location" textbox blank in the
printing preference property of Acrobat 6.0 printer "Adobe PDF" in Window's
printer setting.
Can you please show me the proper procedures to make the automatic PDF
generation work in Acrobat 6.0?
Is there something different that I must do with "PDFMaker"?
The methods that I used in Acrobat 5.0 to set up PDFWriter does not seem to
work with Acrobat 6.0 and PDFMaker.
Your help is greatly appreciated.
Thank you
Andrew