I'm trying to create a VBA routine to use my customer data in an MS-Access 2003 (mdb) database to populate a shipping request PDF form. The problem is that I don't know the names of the fields in the PDF form.
So first I need a utility VBA routine that will simply iterate thru all the fields in the form to retrieve their names.
I've seen plenty of examples on how to populate the fields using something like:
jso.getField("topmostSubform.Page1.fieldName").value = "myValue"
where jso is the JSObject from PDDoc object from AVDoc object. There aren't any good coding examples using JSObject in VBA.
It seems the most closely guarded secret on the internet is how to use jso.getField("topmostSubform.Page1.fieldName") more dynamically so that I can iterate thru all the fields in a PDF form using VBA code in Access.
I work for the Navy (DoD) so my machine is locked down and I cannot install any third party software. I'm actually running Access 2010 but because the Navy has the machines so locked down and they really don't understand how to implement the Trust Center settings properly I have kept my db apps as .mdb to prevent security warnings and issues for my users.
This routine will read through the fields in a PDF form and and put the name of the field as the value of the field, and then save it as a new form so you can see the field names. WARNING: You most likely
Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.
PDF files have been in the limelight due to its unmatched features. Personal documents, emails, business reports and eBooks are all converted into PDF files owing to peerless features provided by it. Adding watermark to a PDF file is a method to se…
*Adobe Acrobat 9 was used for this article. Particular steps may vary depending on software versions.
Adobe Acrobat has many, many variables that my be utilized to customize your forms for clarity and ease of use. The Form Editing Tool will be y…
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …