Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Importing Data into a fillable PDF form Access

Posted on 2006-06-14
10
Medium Priority
?
1,570 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
9 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

877 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