Fill .pdf fields through Access

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Hello all!
I am looking for a way to fill the fields of a .pdf form
through existing access. For Example: a .pdf form would
have a fields for name and address and a I would like to
fill these from an existing address table.
My first I idea was to recreate the .pdf in an access form
and overlay text boxes in the appropriate locations.

Is this a good idea? Is there a tool out there for this?
Has anyone done something similar?

Any help is greatly appreciated.
 
If a pdf form file is an OLE client and can understand VBA or even VBScript
code, or if it can exist as a COM object, you might be able to get it to
work. Try one of the Acrobat newsgroups to get the specifics or an SDK
(software development kit) and you should be able to get an answer.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Hi Joe-
I have been researching the very same thing and have
found that yes it can be done, but you need some help
from Adobe. Adobe does provide a COM compatible API, but
you need to register with the Adobe developer network.
This seemed easy enough so I did, then I found out that
you need to pay for a subscription to get the API, this
seemed easy enough so I did, then they have you fill out
an application that can't be submitted electronicly that
has a bunch of contract lanquage and basically says that
they will get back to you in 4-6 weeks if they think you
are good enough or your purposes noble enough to work
with the Adobe Acrobat API. My purposes are noble and I
still haven't heard back.
Acrobat forms do support JavaScript and you may be able
to hack something together that way, dunno, I've been
working on other projects while I wait to hear back from
them.
Good luck
Ben
 
Back
Top