Creating a Fillable PDF Directly From Access

[CPGDeveloper]

I administer an Access DB -- MS Access Front End/Azure SQL Server Back End

The client has made a request for a button on one of the forms that creates a PDF, with certain information populated from our database...but other information, which does not exist in our db, to be left blank, but fillable -- so that when they open the PDF, they can enter this information directly in the PDF (similar to say a fillable W4 PDF form you'll find on the IRS website).

Does anyone know how I might go about creating something like this, or where I might start researching. Any help or direction would be greatly appreciated.

Thanks in Advance!

 

[welshgasman]

Google is normally my first point of call?

From excel vba create fillable pdf - Google Search

via https://stackoverflow.com/questions/31322260/is-it-possible-to-create-fillable-pdf-from-excel

I found

However you would still need a fillable pdf file to start with?, plus sendkeys apparently can be buggy.

 

[welshgasman]

And another without SendKeys
You do need a full version of Acrobat though I believe?

 

[Joe4]

You do need a full version of Acrobat though I believe?

Yes, I am pretty sure that is true. You cannot create a fillable PDF with the free version.
See here: https://helpx.adobe.com/acrobat/kb/create-fillable-pdf-forms-acrobat.html#:~:text=The free Adobe Reader cannot,Acrobat users can fill in.

 

[welshgasman]

Perhaps try here?

How to make a fillable PDF form without Acrobat | The Jotform Blog

You can make a fillable PDF form online without using Acrobat. Jotform’s PDF Editor will help you create professional PDFs that will save you time and money.

www.jotform.com

Though not sure how you would complete it by automation except for Acrobat full version.

 

[CPGDeveloper]

Thanks for all the replies. Much appreciated.