Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 653
  • Last Modified:

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

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
bcreen
Asked:
bcreen
  • 4
  • 2
2 Solutions
 
Joe Winograd, Fellow&MVEDeveloperCommented:
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
 
bcreenAuthor Commented:
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
 
Joe Winograd, Fellow&MVEDeveloperCommented:
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
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
 
Joe Winograd, Fellow&MVEDeveloperCommented:
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
 
bcreenAuthor Commented:
Thanks folks!
0
 
Joe Winograd, Fellow&MVEDeveloperCommented:
You're welcome! Good luck with the project. Regards, Joe
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now