Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Printing from MS Access with PDF as background

Posted on 2009-04-07
6
Medium Priority
?
344 Views
Last Modified: 2013-11-28
I would like to print some data onto an existing PDF document.  The PDF document I have is a form with many blanks.  I would like the Access DB to fill in the blanks.  Most of the Access data is printing table style, with some pages having a few records and some having many.  My preference would be to have the PDF set as a background for the report, but Access only allows image files as background.  When I converted my PDF to a JPG, the image is very low quality once it is embedded in the Access report.
The non-electronic way to do this would be to print the PDF form, load it into the paper tray of the printer, and print the Access report.  I just think there must be some way to do this electronically.
0
Comment
Question by:littlesandusky
[X]
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
  • 3
  • 2
6 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24093828
littlesandusky,

Why not just create a form in Access to do this?
Use the Form wizard, and in 60 seconds you are done.
;-)

I have seen and created these "Form Image" forms, but they are a pain to create;
(Image storage size, SizeMode, Resolution, Centering, Form Propertie, Form sizability)
...All play a role in how "Good" this will look.

IMHO, creating you own form to simulate the PDF form layout will be *MUCH* easier and faster.

JeffCoachman
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24093901
...and the never look quite "Right".

Here is an example:

JeffCoachman
Access-EEQ-24303911-ImageFormPic.mdb
0
 

Author Comment

by:littlesandusky
ID: 24099448
Unfortunately, It could be a problem for me to "simulate" the form.  I work in a GMP controlled environment and the form that I want to use is a controlled document.  These controlled documents exist in a central document control system.  The danger in creating my own simulated version is that if someone changes the controlled document (even something as simple as a mis-spelled word),  I would need to make my simulated version look exactly the same.

I thought there might be a way to merge the Access data with the PDF form at the time of printing.  I don't need the report in Access to have the background PDF form visible on the screen (although this would help me work out the alignment).
0
Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24101012
Sorry then I mis-understood your question.

"I thought there might be a way to merge the Access data with the PDF form at the time of printing."
There might be.
You will have to do a google search or search the Adobe site.

JeffCoachman

0
 

Accepted Solution

by:
littlesandusky earned 0 total points
ID: 24377386
In the end I was able to print the information from the Access database as a pdf using a pdf converter, then apply the form pdf as a background in Acrobat.  This provided a very clean printout and I was able to save the resulting file electronically.
0
 

Expert Comment

by:dyoung520
ID: 24377604
I just recently was able to convert a PDF to image and use in Access just as you described.

To get a high quality image from the PDF you must import the PDF into an image manipulating software (I used GIMP) and scale the image using resolution to 300 dpi (Print Quality).  Then save the result as a high quality BMP.

You would be able to skip the step of merging the overlay in acrobat!

Cheers,
Dan
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…

660 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