Solved

Ms Access vs Fillable PDF forms | to- and from-

Posted on 2013-11-03
7
629 Views
Last Modified: 2013-11-18
I've searched here, and the most recent questions/solutions on this are very dated.

So, are there add-ins, APIs or other programs or packages that facilitate read-from and writing-to 'fillable' PDF forms?  For instance, the US Governments I-9 and W-4 employment forms?   I'm versed in VBA, and can interface/control the creation, modification, etc, of Word, and Excel files via their object models and interfaces, so was hoping there is something 'out there' I could work with in a similar manner.

Suggestions and/or sample code much appreciated.
-Bill-
0
Comment
Question by:bcreen
[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
  • 4
  • 2
7 Comments
 
LVL 54

Accepted Solution

by:
Joe Winograd, EE MVE earned 500 total points
ID: 39620458
Hi Bill,
I've used the PDF Toolkit in many programs:
http://www.pdflabs.com/tools/pdftk-the-pdf-toolkit/

The command line interface is very nice. Here's the man page for it:
http://www.pdflabs.com/docs/pdftk-man-page/

I've never used the fill-form feature, but it looks as if it will do what you want:
http://www.pdflabs.com/docs/pdftk-man-page/#dest-op-fill-form

Everything I've done with PDFtk has worked well, so I'm guessing fill-form will, too. Regards, Joe
0
 

Author Comment

by:bcreen
ID: 39620521
Hi Joe,

I've looked at PDF Toolkit via the links you provided....have you actually written Ms Access VBA code to interface with PDF Toolkit?  I didn't really see where that was a possibility?

If so, could you provide a code-sample ?  Thanks in advance!

-Bill-
0
 
LVL 54

Expert Comment

by:Joe Winograd, EE MVE
ID: 39620565
Hi Bill,
I have not written VBA code that interfaces with it. I know very little about VBA, but I was going on the assumption that it's possible to call a command line from VBA code. All of my code calls it via <%comspec%>.

<link removed - GaryC123>

Here's a code sample of using it via VBA in Excel (scroll down to the "May 16, 2006, 5:35 am by Anonymous" entry):
http://dailydoseofexcel.com/archives/2006/05/

A web search for "vba pdftk" turns up numerous hits that will make much more sense to you than me. :)   Regards, Joe
0
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!

 
LVL 21
ID: 39620641
For instance, the US Governments I-9 and W-4 employment forms...
For the US Government forms the Paper Reduction Act allows you to create something that is close and has the same information. I have been print I9, W4, Ws2 and all the 1099s formats on plain paper.  I use controls on an Access report to draw the forms along with the data.  

At least for the US Government forms you can draw your own on a report. I have been filing 1000s of forms a year for many years now.

Unless I must submit the form as a filled in PDF, I have yet to have anyone not accept the forms I generate using Access Report not their PDF.
0
 
LVL 54

Assisted Solution

by:Joe Winograd, EE MVE
Joe Winograd, EE MVE earned 500 total points
ID: 39621810
Although it's not for Access, here's a relevant thread at EE that may help as it talks about using PDFtk in Excel VBA:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27666838.html

Regards, Joe
0
 

Author Closing Comment

by:bcreen
ID: 39657450
Thanks folks!
0
 
LVL 54

Expert Comment

by:Joe Winograd, EE MVE
ID: 39657484
You're welcome! Good luck with the project. Regards, Joe
0

Featured Post

Independent Software Vendors: 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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

738 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