Printing PDF from within Access

[steve309]

Hi, i would really appreciate some help please with the following challenge:

I have a file path/name stored in a field in a table, this file/path will always be a valid PDF file. I simply need a piece of code that can print this file from within access to the default printer. These PDF files are drawings and there may be a few for the clients job so i need to loop through using my code and send them one by one to the printer.

I hope this makes sense and thank anyone who can help in advance.

 

[vbajock]

Adobe cripple all the command line options in version 5. Before that you could use the Shell command and pass the reader the /t parameter and it would silently print the document. But in their great wisdom Adobe thought this was just a little too much freebie so they killed it in ver 5. For now you can shell to acrobat using the Shell command (using the document name as a parameter) to open the document, but the user will still have to print it. If you want to spend some money here is a third party tool that will allow you to pass command lines using Shell and do batch jobs and other neat stuff, for 65 bucks:

http://www.pdfstore.com/details.asp?ProdID=39

 

[steve309]

Ok i'll check that out, thanks for your help. Not sure the budget on this one will allow extra expenditure though. I'm suprised there is no other way to do this, i was thinking also along the lines of an ActiveX or Bound object on a an Access report or is that totally off at a tangent?