Populate PDF with Access 2016 and Acrobat Reader (1 Viewer)

ItsJeremy

New member
Joined
Dec 5, 2018
Messages
3
Good day,

What I have:
Microsoft Access 2016 (from Microsoft Office Professional Plus 2016)
Adobe Acrobat Reader DC (Version 2018.011.20055)
all running on a Windows 7 Enterprise machine in a business environment, meaning I do NOT have the ability to install any add-ins or other software.

What I want to do:
Take the values in an Access Table or Query, and populate these fields into an existing PDF fill-in form. The PDF fill-in form was created on a separate computer.

My problem:
All the code examples I have found seem to require the full version of Adobe Acrobat, not just the reader version. Additionally, examples I’ve found required SDK from Adobe to be downloaded. I do not have the ability to do this.

What are my options to transfer values from a Microsoft Access Table or Query, and place those values into a PDF fill-in form.

I’ve been playing around with VBA’s SendKeys, but am not having much luck getting this to work.
Thanks to anyone who can point me in the right direction.
 

theDBguy

I’m here to help
Joined
Oct 29, 2018
Messages
7,693
Hi,

Have you tried the PDF demo from my website?

Be sure to download the non-API version.
 

ItsJeremy

New member
Joined
Dec 5, 2018
Messages
3
I think I can make this work.

But, how do I select a checkbox in XFDF?

Thanks
 

theDBguy

I’m here to help
Joined
Oct 29, 2018
Messages
7,693
Hi,

It depends on what the PDF form is expecting. You could try any of the following: Yes, True, 1, or -1.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom