Solved

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

Posted on 2013-11-03
7
616 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
  • 4
  • 2
7 Comments
 
LVL 52

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 52

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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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 52

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 52

Expert Comment

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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
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…

911 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

22 Experts available now in Live!

Get 1:1 Help Now