Access with Adobe

Posted on 2005-02-28
Medium Priority
Last Modified: 2013-12-03
   How can I overlay an access report over a pdf containing graphics created from Adobe?

Question by:LuckyLucks
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
LVL 44

Expert Comment

by:Karl Heinz Kremer
ID: 13420022
Do you want to do this automatically, or manually (meaning, is this a one-time project, or do you have to do this on a regular basis)?
Do you have the full version of Acrobat available?
Can you program in VBA?

Author Comment

ID: 13420044
many times for Q1
I have acrobat 6.0 full version
LVL 44

Expert Comment

by:Karl Heinz Kremer
ID: 13435260

Acrobat (only the full version) does provide an "inter-application communication" interface. To fully use this, you need access to the SDK, which unfortunately is no longer free. You can get a one year subscription for $99 from Adobe's web site: http://partners.adobe.com/public/developer/acrobat/sdk/index.html

Access unfortunately has a problem with printing to file (at least this was the case last time I checked). So you have to find a workaround for this (check the EE archive for information). The general procedure is to
  - print a PostScript file to file
  - Run Distiller on this PostScript file to create a PDF file
  - Load your background PDF into Acrobat
  - Create a button on the background PDF, make the button the size of the page
  - Set the button to show an icon only (no label), and use the first page of your new PDF file as button image
  - Flatten the document to "burn" in the button image

The IAC interface unfortunately does not provide a straight forward way to overlay two page images, this is why you need to take the detour of creating a button.

You can also use a 3rd party product for the last step: pdftk does support the creation of an overlay. If you manage to create the PDF file, you can then call pdftk as an external application with the correct command line to overlay your documents. pdftk is free, and you can find it here: http://www.accesspdf.com/pdftk/

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.


Author Comment

ID: 13490458
A few questions:
1. What do u mean by load ur pdf into acrobat?
2.Create a button on the background pdf-do u mean as a button on an access report thats been now converted into pdf using the distiller?

LVL 44

Accepted Solution

Karl Heinz Kremer earned 1500 total points
ID: 13490622
Actually, there is now a simpler way to print from Access (or any other application) to a file: In Acrobat 7 Adobe introduced a new feature that allows you by setting a registry key to specify where the Distiller printer (Adobe PDF) should save the file. You can file details in the Acrobat Distiller API Reference (link is on this page: http://partners.adobe.com/public/developer/acrobat/sdk/index_doc.html).

You need to perform the two steps programatically using the IAC or the JS Object (which is accessible via IAC). Again, you need the SDK documentation for this.

Using the 3rd party application is definitely an easier way to accomplish this.

Expert Comment

ID: 22005481
How is it possibile to open a .pdf file with Acrobat, by launching it with VBA?
I have tried something like:
            Set myPdf = CreateObject("AcrobatReader.Application")
            myPdf.Open myAttachment, "Adobe Acrobat"
but it gives error ("ActiveX cannot create the application").
LVL 44

Expert Comment

by:Karl Heinz Kremer
ID: 22005764
sar1973, this question was closed more than three years ago. Your comment also has nothing to do with the original question, so please open a new question.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Update 21-May-2015: I temporarily removed the source code to make major changes to the program. Regards, Joe INTRODUCTION This article presents a solution to a question (http://www.experts-exchange.com/Programming/Installation/Q_28396542.html)…
Inserting page numbers in Portable Document Files not only enhances manageability but also makes them look professional. With numbered pages, the file appears more organized and it becomes easier to search for a particular page. The size and the vol…
In this third video of the Xpdf series, we discuss and demonstrate the PDFtoText utility, which converts PDF files into plain text files. Download and install the software.: You may have already downloaded and installed the Xpdf tools while watching…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question