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-
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-
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks folks!
You're welcome! Good luck with the project. Regards, Joe
ASKER
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-