Print PDF from within Access

[Si]

Is it possible to print a PDF file from within Access 97?

 

[Lynn Trapp]

You will need to download a PDF printer driver, such as Cute PDF.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Rick B]

Yes, but you have to use third-party software. Use something like
"cutepdf.exe" which creates a virtual printer.

 

[Douglas J Steele]

Lynn and Rick both assumed you mean "can you print a report to a PDF file".

I'm wondering, though, whether you meant "can I have Access programmatically
tell Adobe Acrobat to print a PDF file". If that is what you meant, then as
long as you know where Acrobat is installed, you can.

The command line method to have Acrobat print a file is:

"full path to AcroRd32.exe" /p /h "full path to PDF file"

If the full path to the PDF file is stored in a variable strFile, you could
do something like:

Dim strShell As String

strShell = Chr$(34) & _
"C:\Program Files\Adobe\Acrobat 6.0\ReaderAcroRd32.exe" & _
Chr$(34) & " /p /h " & Chr$(34) & strFile & Chr$(34)
Shell strShell, vbHide

Note that there are blanks before and after /p /h in the string above.

 

[tina]

take a look at

http://www.lebans.com/reporttopdf.htm

hth

 

[Lynn Trapp]

tina,
I don't think Stephen has the A97 version available yet, but says it is
coming soon.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Joe Cilinceon]

The pdf995 site has the code to print out any report from access to PDF995
listed at
http://pdf995.com/faq_dev.html It is the last question on the page with a
link to the module code.

http://pdf995.com/index.html You can get pdf995 here

 

[tina]

oops!

tina,
I don't think Stephen has the A97 version available yet, but says it is
coming soon.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Joe Cilinceon]

The pdf995 site has the code to print out any report from access to
PDF995 listed at
http://pdf995.com/faq_dev.html It is the last question on the page
with a link to the module code.

http://pdf995.com/index.html You can get pdf995 here

Oh the method I posted with work in all versions though some modifactions
are necessary. They are noted in the code on what to change for various
versions.

 

[Silvester]

Check out creating pdfs right from access
http://www.lebans.com/reporttopdf.htm