Recent content by joshuar

  1. joshuar

    Filling Adobe forms from Access using VBA

    I'm in the Army and we still manage property using archaic paper based forms from the 1980s. Fortunately these forms have transitioned over to PDFs and can use digital signatures (which is another key feature of the PDF that we need). I am unfamiliar with Crystal Reports but even if I did...
  2. joshuar

    Filling Adobe forms from Access using VBA

    Yes, your previous post on the subject helped me a lot and I think brought me to this forum. I actually modified and used theDBguyPDFDemo.accdb to play around with a couple of these concepts initially, so thank you for that. The limitation I couldn't figure out was how to spawn pages for...
  3. joshuar

    Filling Adobe forms from Access using VBA

    I don't think it is possible to activate many of the functions described here without Acrobat. It might work with Acrobat 9, but keep in mind I'm using Acrobat XI and haven't tested it with any earlier versions (the Scripting guides that most of this stuff came out of was from 7.0 though). I'm...
  4. joshuar

    Filling Adobe forms from Access using VBA

    Forewarning: These next two functions give me errors even when using JavaScript through Acrobat as well as VBA, so I don't think it's a problem with VBA or syntax. Acrobat errors: “(void 0) is not a constructor (void 0) is not a constructor...
  5. joshuar

    Filling Adobe forms from Access using VBA

    Spawning pages from Template without Renaming fields: Templates are pages within the PDF that can be cloned or copied. By default, all fields on the new page are renamed and don't link to each other. It is also created as the last page. With the example below, we create a page from a template...
  6. joshuar

    Filling Adobe forms from Access using VBA

    This thread is a list of a few VBA tricks to getting information from an Access database to a PDF form. I wish I knew how to do this stuff about a decade ago for a big project I was working on, but the resources on how to do it were pretty limited at the time; I had to settle for Access Report...
  7. joshuar

    How do I use VBA to open an Attachment directly from record?

    When interfacing with attachments, the "double click" and the "Open" buttons open the attachment. From there the document can be edited and, when saved, it updates the attachment record directly. If user tried to close the "Attachments" window while the document was still open, the user is even...
Top Bottom