Printing a PDF file

[Guest]

I'm trying to output an Access Report directly to PDF format. I don't want to prompt the user for a file name or path. This will be know. I just want to create a PDF file. I have Adobe Acrobat 6.0 professional. Does anyone know how to do this or where I can find information on this

Thank

Gary

 

[Steve Schapel]

Gary,

Here's how I do it... First of all use code to change the default
printer to the PDF writer. The code I use for this is derived from
Albert Kallal's example available from
http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html
Then just use DoCmd.OpenReport to print to the PDF driver, and then set
the default printer back to normal again.

 

[SA]

Gary:

Stop by our web and look at our PDF and Mail Library for Access. It
supports Acrobat 6 and outputting reports via code to a specific file. No
prompts required.

HTH
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

I'm trying to output an Access Report directly to PDF format. I don't

want to prompt the user for a file name or path. This will be know. I just
want to create a PDF file. I have Adobe Acrobat 6.0 professional. Does
anyone know how to do this or where I can find information on this.

 

[SA]

Steve:

Wish that it was as simple as switching the default printer, but that won't
do the trick in Access 2002 and above even to output the report to the PDF
driver (if you've already printed in Access to some other printer, you've
got to switch Access' printer object as well). Secondly that won't resolve
the issue of prompting for a file name with Acrobat; there's a bit more to
it on a low level basis than that.

 

[Steve Schapel]

Steve,

I have never used Acrobat. The PDF driver I use allows the setting of a
default path and file name, and I guess I just assumed Acrobat would be
the same.

But thanks for the info about the Access printer object in Access 2002
and 2003. I wasn't aware of that.

 

[Rod]

I work for a department store that has several branch
stores that require a Service Work Order Manifest to be
sent to them daily, a separate report for each store. I
developed reports for each store, giving them separate
names. Each report has as its default printer set
to "Adobe PDF". In the Options dialogue box for the Adobe
PDF printer, deselect the radio button requiring the user
to specify a name for the output file. The other option
to be deselected would be the one that prompts to
overwrite the existing file. For ease of execution, all
the reports are generated from a macro with the command
OpenReport with the view set to Print. Hope this helps.

-----Original Message-----
I'm trying to output an Access Report directly to PDF

format. I don't want to prompt the user for a file name
or path. This will be know. I just want to create a PDF
file. I have Adobe Acrobat 6.0 professional. Does anyone
know how to do this or where I can find information on
this.