A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Print PDF from within Access



 
 
Thread Tools Display Modes
  #1  
Old November 15th, 2005, 05:00 PM
Si
external usenet poster
 
Posts: n/a
Default Print PDF from within Access

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


  #2  
Old November 15th, 2005, 05:01 PM
Lynn Trapp
external usenet poster
 
Posts: n/a
Default Print PDF from within Access

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/conrad...essjunkie.html



"Si" wrote in message
...
Is it possible to print a PDF file from within Access 97?



  #3  
Old November 15th, 2005, 05:02 PM
Rick B
external usenet poster
 
Posts: n/a
Default Print PDF from within Access

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


--
Rick B



"Si" wrote in message
...
Is it possible to print a PDF file from within Access 97?



  #4  
Old November 15th, 2005, 06:37 PM
Douglas J Steele
external usenet poster
 
Posts: n/a
Default Print PDF from within Access

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Si" wrote in message
...
Is it possible to print a PDF file from within Access 97?




  #5  
Old November 15th, 2005, 06:43 PM
tina
external usenet poster
 
Posts: n/a
Default Print PDF from within Access

take a look at

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

hth


"Si" wrote in message
...
Is it possible to print a PDF file from within Access 97?




  #6  
Old November 15th, 2005, 07:01 PM
Lynn Trapp
external usenet poster
 
Posts: n/a
Default Print PDF from within Access

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/conrad...essjunkie.html



"tina" wrote in message
...
take a look at

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

hth


"Si" wrote in message
...
Is it possible to print a PDF file from within Access 97?






  #7  
Old November 15th, 2005, 07:33 PM
Joe Cilinceon
external usenet poster
 
Posts: n/a
Default Print PDF from within Access

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

--

Joe Cilinceon



  #8  
Old November 15th, 2005, 07:38 PM
tina
external usenet poster
 
Posts: n/a
Default Print PDF from within Access

oops!


"Lynn Trapp" wrote in message
...
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/conrad...essjunkie.html



"tina" wrote in message
...
take a look at

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

hth


"Si" wrote in message
...
Is it possible to print a PDF file from within Access 97?








  #9  
Old November 15th, 2005, 08:34 PM
Joe Cilinceon
external usenet poster
 
Posts: n/a
Default Print PDF from within Access

Joe Cilinceon wrote:
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.

--

Joe Cilinceon



  #10  
Old November 25th, 2005, 01:10 AM posted to microsoft.public.access,microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Print PDF from within Access

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

"tina" wrote in message
...
oops!


"Lynn Trapp" wrote in message
...
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/conrad...essjunkie.html



"tina" wrote in message
...
take a look at

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

hth


"Si" wrote in message
...
Is it possible to print a PDF file from within Access 97?










 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access Form Print and Print Preview apryl General Discussion 2 September 29th, 2005 09:56 PM
Access 2003 and the Print Manager Byzantine Setting Up & Running Reports 0 May 12th, 2005 02:48 PM
The "Right" web hosting for data access pages?? Ron Ehrlich General Discussion 9 May 6th, 2005 05:49 AM
Why is a French Spellchecker a "required" update for English speak French Spellcheck Required? General Discussion 23 April 26th, 2005 01:17 AM
Print preview closes Access Lee Setting Up & Running Reports 2 January 21st, 2005 07:39 AM


All times are GMT +1. The time now is 11:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.