Export an Access 2000 report to pdf file using visual basic

[sb]

I use VB 6 and Acrobat 4.
I need to export Access reports to PDF files using VB. I can't use the "Acrobat PDFWriter" because it asks interactively for the file name. There is no way to "export as pdf file" from within Access.
Do you know if an ActiveX exists to do that? Or another idea?

Thanks a lot,
SB.

 

[MickTheBelgian]

define a good postscript printer in windows and select print-to-file

You can then convert the postscript *.prn to a *.pdf using ghostscript

http://www.ghostscript.org

I hope you have a week or two to figure it all out!!!

 

[mpitts]

Please refer to the page at the URL below:

http://www.mvps.org/access/reports/rpt0011.htm

 

[mpitts]

By the way, the following is applicable to Access 2k on how to repress the dialog.

http://www.adobe.com/support/techdocs/66ca.htm

 

[sb]

Thank's to mpitts and Mick for your participation.
I've solved my problem using the PDF Distiller, changing the default printer to it. There is to user prompt for the file name, the file is sent by default to a special directory called PDF Output. In the code I wrote a loop to wait for the file beeing created. Then I just move it to the right place with the right name.Thank's again,
Sylvie.

 

[sb]

Oops, I meant "There is NO user prompt for the file name"...