Solved

Importing Data into a fillable PDF form Access

Posted on 2006-06-14
10
1,479 Views
Last Modified: 2012-06-27
I have a fillable PDF and I would like to import data from an access database into the form. I know I can click on import data within the PDF and import a text file, however I'd like to set up an access form which will allow me to click a button and will automatically generate the text file and import the data into the form. My largest hurdle right now is figuring out how to control an acrobat 6.0 document from access vba. I can't seem to find a reference library to allow me to import data into a pdf document. Any help would be greatly appreciated.
0
Comment
Question by:huntdj0
[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
  • 2
  • +2
10 Comments
 
LVL 66

Expert Comment

by:Jim Horn
ID: 16902871
Hi huntdj0,

>I have a fillable PDF
Define 'fillable PDF'.  Last I remember, the ability to write and data into a PDF documente required some kind of Adobe server product, which had a license fee of $50,000.

>figuring out how to control an acrobat 6.0 document from access vba.
Adobe has a 'Adobe JavaScript Scripting Reference' manual, 682 pages long.  
There's also the 'Acrobat Interapplication Communication Reference' manual, a quick read of 400 pages.

Do a search on the Adobe site for AcroJS.pdf and IACReference.pdf, and I'm sure you'll find it.

Good luck, as coding in Access VBA (or anything VB) to PDF is not easy.

-Jim


Cheers!
0
 
LVL 85
ID: 16903680
Agree with jim, manipulating PDFs in this manner from with Access can be tough. Here's a pretty good start:

http://www.planetpdf.com/

There are likely some 3rd party controls which will allow you to do this, but be very concerned IF you need to deploy this - often they are quite specific as to what must be installed on the workstation/server in order to function correctly.
0
 

Author Comment

by:huntdj0
ID: 16904002
Thanks for your comments.

I have been poking around some more and found that an acrobat object in access has a menuItemExecute member. I am trying to figure out how to run the import forms data menu with this command.

Any hints there?

Devin
0
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 
LVL 85
ID: 16904871
Not really ... have you tried the Adobe forum? You can put a 20 point "pointer" question in that forum to this question, or have CS move this question to that forum.
0
 

Author Comment

by:huntdj0
ID: 17288876
My question was not answered by any of the above comments.
0
 
LVL 66

Expert Comment

by:Jim Horn
ID: 17288973
Actually, it was, it's just that the answer is not user-friendly enough for a typical Access developer to easily incorporate into their apps, and costs less than $50k.   I'm guessing that a couple of years from now, a version of Adobe Acrobat Professional will be out that is.

I have no objections to a Delete-Refund here.
0
 

Author Comment

by:huntdj0
ID: 17289444
I actually found a way to fill the form. It's a bit of a round about way but it worked for my purpose. I wanted to fill out the FDA MedWatch report form. What I did was open an instance of notepad from access and basically wrote in text to code the pdf variables and their values. I got the names of the variables by exporting data from the pdf form. What you get when you export the data is an .fdf file that references the original .pdf version. When you open the .fdf file, it opens the .pdf and fills in the data specified in the .fdf file. So i was able to open the .fdf document from access, which opens the .pdf and fills in the data.

Like I said, I sort of round about way, but it worked and was a lot less expensive then $50k.

0
 
LVL 61

Expert Comment

by:mbizup
ID: 17290135
Since the author posted a solution, Ill change the recommendation to:

PAQ/Refund

(If there are no objections :-)

0
 

Accepted Solution

by:
ee_ai_construct earned 0 total points
ID: 17318499
PAQ / Refund
ee ai construct, community support moderator
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

626 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