Results 1 to 5 of 5

Populate PDF from Access VBA

  1. #1
    scott0_1 is offline Advanced Beginner
    Windows Vista Access 2013 32bit
    Join Date
    Apr 2018
    Posts
    63

    Populate PDF from Access VBA

    Hi All,

    I've tried asking this in the Adobe forums, but no luck. Hopefully someone here can help.

    I'm trying to populate a fillable PDF with data from Access from the push of a button on an Access form. Ideally, the user doesn't even see Adobe opening up. I would like the form to save and attach itself to an email.



    Only one of out computers has Adobe Pro and I cannot compile the Access DB, so I cannot use any libraries that aren't included with the free version of Reader DC.

    So far, the best solution I have found is writing an .XFDF file and opening it in a shell. This isn't ideal, but it works. I just can't help but feel there is a better way of doing this. Writing the .XFDF file line-by-line in VBA is painstakingly long and tedious. I do not have access to any authoring software (that I know of) to help me write it.

    Thanks for any ideas you may have!

    Scott

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    7,032
    normally you use access to fill pdfs, not the other way around.
    youd have better luck having users fill in an excel sheet, and load data from that.

  3. #3
    scott0_1 is offline Advanced Beginner
    Windows Vista Access 2013 32bit
    Join Date
    Apr 2018
    Posts
    63
    Quote Originally Posted by ranman256 View Post
    normally you use access to fill pdfs, not the other way around.
    That's what I'm trying to do... I'm not sure if I wrote it backwards? I re-read it, and I think it's correct?

    Quote Originally Posted by ranman256 View Post
    youd have better luck having users fill in an excel sheet, and load data from that.
    I'm trying to make it one-stop-shopping for the users. Most people here are not computer literate, so if I have a form with a button that says "GO", then populates the PDF with the recordset they chose, that would be awesome. Trusting them to put it into Excel and push a few extra buttons is dicey. Plus, I'm trying to create a system that cuts down on steps. Some of the folks around here don't want to buy what I'm selling!

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    45,538
    To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.

  5. #5
    scott0_1 is offline Advanced Beginner
    Windows Vista Access 2013 32bit
    Join Date
    Apr 2018
    Posts
    63
    Quote Originally Posted by June7 View Post
    I had a look at this earlier... Looks promising, but I can't download files at the office! Hopefully I'll feel like looking at it tonight when I get home!!!!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Populate outlook calendar from access
    By Don T in forum Access
    Replies: 5
    Last Post: 07-13-2013, 11:20 AM
  2. Using access calendar to populate textbox
    By khartoum in forum Access
    Replies: 14
    Last Post: 06-29-2012, 08:13 AM
  3. Replies: 1
    Last Post: 03-19-2012, 12:59 PM
  4. Access Search and populate
    By jgolba99 in forum Access
    Replies: 1
    Last Post: 12-27-2011, 02:12 PM
  5. Populate data from access
    By bishop in forum Access
    Replies: 1
    Last Post: 10-17-2011, 02:21 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums