Solved

Importing Data into a fillable PDF form Access

Posted on 2006-06-14
10
1,439 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 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
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 
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
 

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

734 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