Is this possible to do in MS Access?

[Boberto]

Greetings everyone!

One of the functions of my job at work is to pull pdf sheets of our vendors data and compile into one pdf. Our library of pdfs is HUGE and so it's very time consuming going through all the folders and grabbing specific ones.

So my question is.... Would it be possible to create an access program where I can just click on the options I want, and Access goes and grabs those pdfs and complies them all into one report? If not, does anyone know of a program that would do something like that?

Thanks in advance!

[rpeare]

you might be able to do it if you had a full version of the adobe software installed but I've never done it. Here's an example of the code needed:

http://www.access-programmers.co.uk/forums/showthread.php?t=212734

from the comments in the code itself:

'Assumes:Ref Scripting FSO, and Adobe Ac
'     robat Found in Adobe5.0 SDK .
'Again
'You must have Adobe Acrobat 5.0 SDK Installed
'otherwise you will get errors when Late Binding the AdobeDocument Objects duh!

i

[Boberto]

Thanks for the info rpeare!

I do have Acrobat XI at work and that's what we currently use to make forms and combine pdfs. I'll have to take a look at it.