Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 532
  • Last Modified:

Access with Adobe

   How can I overlay an access report over a pdf containing graphics created from Adobe?

  • 4
  • 2
1 Solution
Karl Heinz KremerCommented:
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?
LuckyLucksAuthor Commented:
many times for Q1
I have acrobat 6.0 full version
Karl Heinz KremerCommented:

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/


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

LuckyLucksAuthor Commented:
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?

Karl Heinz KremerCommented:
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.
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").
Karl Heinz KremerCommented:
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now