468,733 Members | 1,616 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,733 developers. It's quick & easy.

Use pdf as report

200 100+
What is the best way to use a pdf file as the basis for a report? I have a Texas Work Comp. file that I would like to use as a report form. The original pdf fills an 8-1/2x11 page nicely within acrobat. However, when bringing the pdf into Access I am having issues with scaling. If I create an unbound object or simply drag and drop the pdf file into the design screen of my report, it scales much smaller that the original pdf. I've also tried the scaling options from the report's property sheet.
Feb 28 '09 #1
4 4038
8,800 Expert 8TB
I have had excellent results using the following technique:
  1. In Adobe
    • Open your Report
    • Select Edit, Copy File to Clipboard
  2. In Access
    • Make sure you are in Report Design View
    • Select the Detail Section of the Report
    • Select Edit, Paste
    • Your Report should now be displayed in an Unbound Object Frame within the Report's Detail Section
    • Select File, Page Setup
    • Set Top, Bottom, Left, and Right Options to .25
    • Right Click the Unbound Object Frame, Properties
    • On the Format Tab, set the Size Mode Property to Stretch
    • Adjust Object Frame (Report) to the desired dimensions using the Sizing Handles
    • Periodically check your adjustments via File, Print Preview
    • Good Luck, and Good Night
Mar 1 '09 #2
200 100+
Thanks ADezii, but doing the steps mentioned really distorts the final result. I need to find another way. The strange thing is, the actual pdf in Acrobat measures 8.5" in width using Adobe's measuring tool. Looks perfect on an 8-1/2x11 page with .25 borders. But when you copy/paste that same pdf into Access, it comes in at a width of 6.5...WHAT??? Why is Access scaling the original pdf?

Workaround: I found if you bring the pdf into Illustrator, scale to 11x14, save as pdf within Illustrator, then bring the pdf into Access, it looks good. Way too much work IMO and I'm looking for an easier way if anyone knows how.


Mar 1 '09 #3
1,923 Expert 1GB
If you have MS Access 2007, Adobe Acrobat Professional, and the MS Print to PDF add-in that came out with Office 2007, you should be able to design your form in access as a report form that simulates the pdf form as close as you can get it (one-time design work), then output the Access report directly to pdf after opening your report in preview mode in ms access. You would place the code behind a button on the form you use to launch your Access reports as shown below.

Note that with the Access PDF add-in, you can output using acFormatPDF natively from MS Access.
Expand|Select|Wrap|Line Numbers
  1. Private Sub btnSendToPDF_Click()
  2. Dim strAccessRptName As String    ' captured when Access report is previewed
  3. DoCmd.OutputTo acOutputReport, strAccessRptName, acFormatPDF, "c:\PDF Reports\" & strAccessRptName & ".pdf", False
  4. End Sub
The above file path assumes that you have set up a folder called PDF Reports on the root directory of your C drive.
End Sub
Mar 1 '09 #4
200 100+
Interesting solution. I'm sure this would keep the size of the DB down as opposed to using images to represent the pdf.

Thanks for your help,

Mar 1 '09 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Nathan Bloomfield | last post: by
6 posts views Thread by Bob Alston | last post: by
1 post views Thread by lorirobn | last post: by
1 post views Thread by monskie | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.