[AccessD] Automate PDF

Rockie - I am working on a similar project with a government form.....over
200 fields !!
It's really pretty simple, but there is one "kicker".
The workstation that generates the data on the form must have Acrobat
Professional installed.
The Reader won't do.
Once that happens, it's so simple:
1) Make a reference to the Acrobat type library (.tlb)
2) You instantiate a new PDDoc and open it in VBA (see the documentation at
Adobe.com and the great user forums there)
3) You reference a method called getNthfieldName to iterate thru all of the
form field names.
Now you know all of the field references.
4) You develop an XREF table between the table column names and the form
field names.
5) You assign each column to a form field.
6) oPDFdoc.getField("thisfield").Value = oRST.Fields("this table
column").Value
Implement the above with the XREF table.
Another trick: make the column names of the source query or table the same
as the PDF field names....then you don't need the XREF table. Now it's
really simple !!!


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-
> bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
> Sent: Tuesday, November 04, 2014 3:42 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Automate PDF
>
> Just to make it more complicated, I think they need the electronic form
> of
> the pdf to send back to the government agency in question.
>
> R
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of James Button
> Sent: Tuesday, November 04, 2014 12:05 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Automate PDF
>
> Or - the crude old fashioned way
> Print the PDF and then overprint that output with the data
> appropriately
> spaced
> -
> As in mailmerge into a .doc that is mostly newlines, tabs and spaces
>
> JimB
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan
> Harkins
> Sent: Tuesday, November 04, 2014 7:24 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Automate PDF
>
> Does the client have the reader or the full-powered suite? You could
> export
> the information to a delimited text file, if they know how to get a pdf
> to
> import it.
>
> Susan H.
>
> On Tue, Nov 4, 2014 at 2:16 PM, Rocky Smolin <rockysmolin at bchacc.com>
> wrote:
>
> > Dear List:
> >
> > Is there a way to fill in the blanks in a PDF form?  I have a client
> > who has a government form that they fill by hand and it takes a huge
> > amount of time and is, of course, somewhat error prone. .  But most
> of
> > the data is in the database I wrote for them.  Is there a way to push
> > that data into a pdf form.  BTW this is still a 2003 app.
> >
> > MTIA
> >
> > Rocky Smolin
> > Beach Access Software
> > 858-259-4334
> > www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com
> > <http://www.e-z-mrp.com/>
> > Skype: rocky.smolin
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com