Fill a PDF with SQL data-record specific

I know the question has been asked a million time but.....

I have a predefined PDF form with fields (it is a government form). I need the code to ( I do not need help getting to the record or fields) open the PDF, assign values to the fields and then print it OR view it (I need to be able to oofer the option for both. Acrobat is installed on every machine that will generate the form.

Thanks in advance
beechdriver100Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Karl Heinz KremerCommented:
If Acrobat is installed on every system, there is no need to use a 3rd party tool like suggested in the previous comment. You can use VB to access the form fields via the VB/JavaScript bridge. I wrote a blog post some time ago that showed how to read form fields via VBA - the same mechanism applies when writing fields from VB. Take a look:

http://khkonsulting.com/2010/09/reading-pdf-form-fields-with-vba/

Let me know if this works, or if you need more information.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
beechdriver100Author Commented:
Thank you. Well written
Karl Heinz KremerCommented:
I just noticed that you posted a comment an an already closed question about how to view the document after making the modifications. In general, it's a bad idea to post followup questions on already closed questions - almost nobody will see your comment. You have a much better chance of getting an answer when you start a new question.

Are you familiar with the API documentation? The AVDoc methods will allow you to display the document:

http://livedocs.adobe.com/acrobat_sdk/9/Acrobat9_HTMLHelp/IAC_API_OLE_Objects.103.33.html
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Adobe Acrobat

From novice to tech pro — start learning today.