Access to XFDF

  • Thread starter Thread starter chris48178
  • Start date Start date
C

chris48178

Hello all, first time poster, hope you can help...

I have an MS Access 2002 Database with 1 Table and 650+ Records.

Ultimately, I would like a PDF document organized with data from the
database.

I already have the PDF form with the appropriate fields, and have
tested a sample XFDF file.

What I need to do now is get each record of the DB to export, or be
extracted somehow to individual XFDF files in the following format:

<?xml version="1.0"?>
<xfdf xmlns="http://ns.adobe.com/xfdf/" xml:space="preserve">
__<fields>
____<field name="-PDF_FORM_FIELD1-">
______<value>-VALUE OF DB CELL 1-</value>
____</field>
____<field name="-PDF_FORM_FIELD2-">
______<value>-VALUE OF DB CELL 2-</value>
____</field>
____<field name="-PDF_FORM_FIELD3-">
______<value>-VALUE OF DB CELL 3-</value>
____</field>
__</fields>
<f href="-LOCATION_OF_PDF_FORM-.pdf"/>
</xfdf>

Also, I would like the file name to be derived from the contents of one
of the fileds (i.e. -VALUE OF DB CELL 1-.xfdf).

I am fairly new to Access, and do not have much coding/scripting
experience.
 
chris48178 said:
Hello all, first time poster, hope you can help...

I have an MS Access 2002 Database with 1 Table and 650+ Records.

Ultimately, I would like a PDF document organized with data from the
database.

I already have the PDF form with the appropriate fields, and have
tested a sample XFDF file.

What I need to do now is get each record of the DB to export, or be
extracted somehow to individual XFDF files in the following format:

<?xml version="1.0"?>
<xfdf xmlns="http://ns.adobe.com/xfdf/" xml:space="preserve">
__<fields>
____<field name="-PDF_FORM_FIELD1-">
______<value>-VALUE OF DB CELL 1-</value>
____</field>
____<field name="-PDF_FORM_FIELD2-">
______<value>-VALUE OF DB CELL 2-</value>
____</field>
____<field name="-PDF_FORM_FIELD3-">
______<value>-VALUE OF DB CELL 3-</value>
____</field>
__</fields>
<f href="-LOCATION_OF_PDF_FORM-.pdf"/>
</xfdf>

Also, I would like the file name to be derived from the contents of one
of the fileds (i.e. -VALUE OF DB CELL 1-.xfdf).

I am fairly new to Access, and do not have much coding/scripting
experience.
Click to expand...
 
Back
Top