By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,640 Members | 2,279 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,640 IT Pros & Developers. It's quick & easy.

Use pdf as report

tuxalot
100+
P: 200
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
Share this Question
Share on Google+
4 Replies


ADezii
Expert 5K+
P: 8,638
@tuxalot
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

tuxalot
100+
P: 200
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.

Thanks,

Tux
Mar 1 '09 #3

puppydogbuddy
Expert 100+
P: 1,923
tuxalot,
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
  5.  
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

tuxalot
100+
P: 200
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,

Tux
Mar 1 '09 #5

Post your reply

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