These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Creating PDF from Word document in Access

ncsthbell
Registered: Nov 6 2007
Posts: 13

I have an MS Access application (vb). This application opens MS Word and creates 2 word documents that are saved to a folder. I need to be able to create a process that will allow the user to click on a button in this application and it will create these 2 docs AND write them to a single PDF. OR, write them to separate PDF files and then combine them into one. I have read so much on the forums that I am confused about the best method to use for this. I also have 2 access reports that I will have to combine into this same single pdf. This whole process has to be automated, without any user interface except clicking on one button to initiate the code.

Any help would be appreciated!!

daka630
Expert
Registered: Mar 1 2007
Posts: 1420
Just an observation here, but, might not appropriate modifications in the MS Access application provide a cleaner resolution to the issue?

Be well...

Be well...

ncsthbell
Registered: Nov 6 2007
Posts: 13
Not really sure what you mean by "appropriate modifications". Can you clarify? BTW, I inherited the support for this application so basically, I just have to 'make things work'....
Bottom line is I have 2 access reports and 2 word docs that my users want the end result to be one PDF file. I can use 'PDFMaker' in the application and it works great to create the pdf for the 2 access reports, however, I can't figure out how to automate getting the word docs converted to pdf and inserted into this same pdf file. That is what I am trying to get some direction on. My first solution to the users was to convert these 2 word docs to access reports.... they won't budge! So, I have to find a way to do it, even if it means jumping through lots of hoops.
I read some about Distiller and it looks like I can use that and convert the word docs to PDF. BUT, I need to automate this process and I can't find info enough about an API that I could use in my app for Distiller. IS there one? If I get that info, then I still faced with the issue of how to get the PDF which contains the converted word docs and the PDF of the access reports into one document... programatically! You know that sometimes users think you can do anything.
Any suggestions would be appreciated!!