Printable View
Hello,
I would really like to know how to create fillable PDF files with an Access form. I know how to print a form and create a static PDF file but would like one that automatically converts blank text boxes into fillable fields.
If it requires 3rd party software that is OK, even if it isn't free, as long as it works.
Thanks in advance.
Forms in Access are fillable. Are you trying to get the form our of Access and still have it fillable? If that is the case, which format are you trying to bring it out as?
Hi baadil and thanks for the reply,
Yes, though we can enter data into Access from our office, the problem is we send these specification sheets to vendors who do not have MS Access, not to mention would need folder access rights and so on. I need to print out PDF documents of forms I created in Microsoft Access. Currently I can do a regular printout of a CutePDF (any control boxes with data in it will print with data, but control boxes without data will just print a box, and you cannot fill data into it later). I made over 30 different specification sheets (forms) that we currently generate as a PDF. The vendors we email our PDFs out to must fill in information by hand, which is not the best since handwriting isn't always legible, and they prefer sheets they can fill in on their computers (either excel or a fillable PDF, both of which we currently can't do with Access forms). I hope this explains exactly what I need and why I need it.
Thanks.
this works for me using Access 2007 and Adobe Acrobat 9 Pro
1. Save the forms as Pdf.
How? on MS Access click Office button, -->Save As --> Pdf of Xps (Save as type pdf) click Publish button.
2*. After saving the MS Access form to Pdf file, open the .Pdf File using A Acrobat Pro, hit Shift+Ctrl+7 keys or from Forms menu select Add or Edit Fields.
A pop up message "Do you want Acrobat to detect form field for you?" Click Yes. A welcome to edit message will appear. Click OK button. then Click Close Form Editing. Save the pdf and distribute to clients!
or alternative to step 2.
open the pdf file, on Forms menu select --> Start from wizard, Create or Edit Form pops up, select --> An existing electronic document, click Next button, select Use the current docment click next. Click Ok button on the next window. Click Close Form Editting button (or simply save the doc)
well, as for collecting the info from pdf to ms access i have no idea. but if you use ms excel there are plenty of samples posted in this forum how to save excel data to access tables. if i were you i'll use excel, if the data from clients are to be saved to access table automatically. less manual encoding