Select and print PDFs from storage archive 1

[HenryAnthony]

Hi,

We have many PDFs stored on a network. I would like to develop an application that makes it possible to select a PDF and then print it - preferably in a particular order - from within Access. Does anyone have any experience or ideas on how this could be accomplished.

Best regards,

Henry

 

[genomon]

http://ourworld.compuserve.com/homepages/attac-cg/acgpdf.htm

is a good place to start - 3rd party library for Acrobat printing & email. We use this in conjunction with the FileSystem object to automate image retrieval & printing.

 

[HenryAnthony]

Thanks Genoman,

I downloaded the trial but have not yet been able to find anything in the help files that refer to the desired functionality. I will dig deeper though.

Best regards,

Henry

 

[genomon]

There is a great help file included with the trial, but all the FileSystem manipulation is strictly VBA. If you are unfamiliar with it, here is sample code to copy a file:
FIRST ADD A REFERENCE to the Microsoft Scripting Runtime library.

Public Sub CopyFiles()

On Error GoTo copy_error

Dim strSource As String
Dim strDestination As String
Dim fs As Object

Set fs = CreateObject("Scripting.FileSystemObject")
strSource = "G:\etc\*"
strDestination = "C:\etc\"
fs.CopyFolder strSource, strDestination
Set fs = Nothing

copy_exit:
Exit Sub

copy_error:
MsgBox "File Copy Error " & Err.Number & vbCrLf & _
Err.Description
Resume copy_exit

End Sub

I can still help out with the PDF stuff,too; there is sample code included in the download as well.
Hope this helps!
-Geno

 

[HenryAnthony]

Geno,

My code skills are at a rather simplistic level. I have however had some success working with FileSystem stuff. I will see if I can make some sense of this.

Thanks soooooo much for helping. I give you a star!

Henry

 

[genomon]

ALL RIGHT HENRY -thanks much! The part of the ACG Help you need for code samples: Contents tab|Using the PDF And Mail Library|PDF Pro Edition|PDF Class|Class Properties and Methods. Good Luck!!

 

[HenryAnthony]

OK, that helps even more. I find that the ACG folks are in Ann Arbor. I am also in the area and may contact them.

Best regards,

Henry