Solved

Importing Data into a fillable PDF form Access

Posted on 2006-06-14
10
1,326 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
  • 3
  • 2
  • 2
  • +2
10 Comments
 
LVL 65

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 84
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
 
LVL 84
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

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

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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

758 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now