UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Fillable Pdf Forms, Any Version    
 
   
theDBguy
post Apr 10 2012, 11:52 AM
Post#1


UA Moderator
Posts: 78,612
Joined: 19-June 07
From: SunnySandyEggo


There have been many questions in the forums about how to auto-fill a PDF form with data from an Access database, and the most common response is to use the Acrobat DLL to manipulate the PDF file.

Recently, UtterAccess user "lex" introduced me to XML Forms Data Format (XFDF) that Acrobat created to allow XML data to be merged with fillable PDF forms. Using this file does not require any DLL but the implementation relies on the capabilities of your PDF authoring software or reader.

The attached demo is just a simple example of how to create an XFDF file with a well-formed XML data from an Access Form. The functionality can be extended to retrieve the data from a query or table. This demo could also be extended to allow the user to select the PDF file and "map" its fields to the table or query fields (but I think that would require using the Acrobat DLL, perhaps we'll save that for future versions of this demo).

This demo was created and tested using Access 2007. A MDB version is also included in the zip file but it was not tested in an Access 2003 environment.

Appreciate any comments or suggestions...

Note: Please remember that the functionality of the fillable PDF form will depend on your PDF authoring software. For example, if you only have Adobe Reader installed on your machine, it will not allow you to save the filled-up form as a PDF file (you can only print it).

Update: Somebody asked me how they can find out the names of the fields in the PDF form, so I thought I would post the answer here just in case others might find it useful.
Basically, if you have a copy of the full version of Acrobat, you can use the Select Object Tool to see the name of each field. Depending on the version of Acrobat you're using, the menu path could be something like: Tools > Edit or, Tools > Advance Editing > Select Object Tool. Or, if you're using Adobe LiveCycle Designer, the menu path would be something like: Windows > Hierarchy.
However, if you don't have a copy of the full version of Acrobat and your PDF reader does not have the capability to display the field names on the form, you can upload a copy of your form to this website: AspPDF Form Field Finder, and you will get a list of all the field names in your PDF file.

Enjoy! Hope you find this additional info useful...

More Update: User marineco brought a potential issue to my attention. It seems that XML parsing of the XFDF file could fail if your data fields contain either the ampersand "&" or the less than "<" symbols. The attached modified version (1.1) uses one approach to handle this issue. If you find other characters or symbols that cause XML errors, please let me know. Thank you.
Attached File(s)
Attached File  theDBguyPDFDemoV1.zip ( 98.57K )Number of downloads: 783
Attached File  theDBguyPDFDemoV1.1.zip ( 102.44K )Number of downloads: 1371
 
Go to the top of the page
 
Esteban
post Jun 17 2020, 11:36 AM
Post#2



Posts: 1
Joined: 17-June 20



Muchas gracias por compartir su conocimiento. Gracias a ello he podido resolver un problema como era el de rellenar los campos de un PDF editable desde Excel con Visual Basic 6.0
Llevaba 4 días buscando una solución, y apunto de abandonar.....
Gracias y un saludo.
Go to the top of the page
 
theDBguy
post Jun 17 2020, 11:45 AM
Post#3


UA Moderator
Posts: 78,612
Joined: 19-June 07
From: SunnySandyEggo


Hola Esteban. Bienvenidos a UtterAccess!

welcome2UA.gif

Por favor, dame unos minutos para traducir lo que dijiste antes yo te respondo. Gracias.

(Sorry for my bad Spanish. I didn't use Google Translator.)

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
theDBguy
post Jun 17 2020, 11:49 AM
Post#4


UA Moderator
Posts: 78,612
Joined: 19-June 07
From: SunnySandyEggo


Creo que te entendi. Muchas gracias por me dejas saber. Buena suerte con tu proyecto!

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
FrankRuperto
post Jun 17 2020, 12:14 PM
Post#5



Posts: 1,219
Joined: 21-September 14
From: Tampa, Florida USA


QUOTE (Esteban)
Muchas gracias por compartir su conocimiento. Gracias a ello he podido resolver un problema como era el de rellenar los campos de un PDF editable desde Excel con Visual Basic 6.0
Llevaba 4 días buscando una solución, y apunto de abandonar.....
Gracias y un saludo.

Frank's translation:

Many thanks for sharing your knowledge. Thanks to it, I have been able to solve a problem like that of filling the fields of an editable PDF from within Excel using vb6.
I had been looking for a solution for 4 days, and almost abandoned the effort.
Thanks, I salute you.
This post has been edited by FrankRuperto: Jun 17 2020, 12:23 PM

--------------------
Currently supporting pawnbrokers that use my store management system developed with Access 2010 on Windows7. Experienced with Informix, Oracle & PostgreSQL db's.
Go to the top of the page
 
theDBguy
post Jun 17 2020, 12:19 PM
Post#6


UA Moderator
Posts: 78,612
Joined: 19-June 07
From: SunnySandyEggo


Hi Frank. Thanks for the assist. I'll have to call you next time I need help translating and speaking (writing) Spanish. I'm not very good with it yet. Que tenga un buen dia!

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
FrankRuperto
post Jun 17 2020, 12:21 PM
Post#7



Posts: 1,219
Joined: 21-September 14
From: Tampa, Florida USA


Hi DBG, you're welcome, and may you also have a great day thumbup.gif
This post has been edited by FrankRuperto: Jun 17 2020, 12:29 PM

--------------------
Currently supporting pawnbrokers that use my store management system developed with Access 2010 on Windows7. Experienced with Informix, Oracle & PostgreSQL db's.
Go to the top of the page
 
soupy8728
post Jul 28 2020, 08:25 PM
Post#8



Posts: 1
Joined: 28-July 20



Hello,

I just found this site and I'm really new to all of this. I've downloaded the files and unzipped them. I opened the form and populated the pdf. Am I missing something? Is there supposed to be some instructions on how you did it? Again, I'm new to all of this so forgive me if I am missing it. Thanks.
Go to the top of the page
 
theDBguy
post Jul 28 2020, 09:04 PM
Post#9


UA Moderator
Posts: 78,612
Joined: 19-June 07
From: SunnySandyEggo


Hi. Welcome to UtterAccess!

welcome2UA.gif

Unfortunately, I wrote the demo with developers in mind. It's supposed to show how it's possible. If you need some guidance, let us know what part you're having difficulty with, and we'll try to assist.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    6th August 2020 - 05:23 AM