I often recieve pdf forms or excel based forms from various groups, which need to be filled out with lots of information that is housed in a MSAccess database. It takes a lot of time to get all the boxes and text formats perfectly exact in MSWord in order to use the mail merge function. I asked someone what the best way was to do this, and they have been pasting the pdf file into a report in access and then draggin in the fields from 'field list' to populate the report. The PROBLEM is that when I drag in the pdf image, it is all smeared. I am loosing QUALITY. In the past there was an 'insert' -> 'create from file" option in MSAccess which had allowed this person to accomplish this. I'm not seeing it in Office07.

Am I taking the best approach?

How can you get the pdf into a report so that it will print normally with correct margins and look non-smeared?

Thanks,

No one replied, so I thought I should share what I discovered. Someone might find it helpful. When you import a pdf into a report in MS Access, it will deteriate the image file, I know no way around that. Interestingly though, the original quality is in there. If you double click the image file from desing mode, it will open in Adobe with perfect quality.

So, one way to make auto forms work is to use the old typewriter method. Use the bad quality image file that you import to line up the boxes you need to query into the form. Then, from adobe, print the form you want to fill out. Place these good quality forms in the printer. Delete bad quality background pdf in Access but leave the queried input boxes. When you print these boxes they will be in the correct place on the page and it will be in original quality. For my printer I set the pdf image file to 8" x 10.5" to get things to line up exactly. Gets a little tricky with multi-page forms.

I have been able to place a pdf in a report and place text boxes over itto fill in the blanks.

How were you selecting the part of the PDF wanted and inserting it on the report?

What version of Acrobat are you using?

Here is a previous post on the subject

http://www.utteraccess.com/forum/Embeded-PDF-document-Acc-t1938856.html

hope this help...

Thankyou. That helped a lot.

I use Adobe Reader, the standard version. After reading I got the gist of the idea that I need to copy the relevant content without the margins as closely as possible. I used the 'snapshot tool' in Adobe to select just the pdf content and then pasted directly into a report in Access. This comes across very clear. Stretching the image still decreases its quality, even if you are shrinking it, so I just messed with the zoom in adobe until its native size was close to the 8" x 10" that I needed in Access so that I could leave the image property on 'clip'.

You're welcome.

Glad you were able to figure out the key elements to the process.