Results 1 to 1 of 1

Issue Populating PDF Checkbox via VBA that didn't Exist on Previous Form

Threaded View

MeleaB Issue Populating PDF Checkbox... 11-17-2016, 08:09 PM
  1. #1
    Registered User
    Join Date
    05-20-2016
    Location
    Greensboro, NC
    MS-Off Ver
    Office 365 Home
    Posts
    1

    Issue Populating PDF Checkbox via VBA that didn't Exist on Previous Form

    Hello.

    I would be most grateful if anyone could shed some light on this issue as I have spent hours and hours on it, as well as combing through forums. I'm sure it has a very simple solution but I haven't solved it!

    I had written VBA code that successfully populated an IRS form (1095c 2015) from Excel data. This included form fields that excepted text and numerical data as well as checkboxes.

    e.g.
    The form field with name: "topmostSubform[0].Page1[0].EmployeeName[0].f1_002[0]" is given a value for the employee's name, such as "John Smith"
    The form field with name: "topmostSubform[0].Page1[0].Line17[0].c1_011[0]" is a checkbox which is given a value of "1" or "0"

    However, when trying to perform the same task on the 2016 version of the same form, it is not allowing me to populate any of the checkboxes, although I can still populate the other fields with no problem. Some of the form names are slightly different in the 2016 version, but my code has been updated to reflect this.

    So, if I now try to populate the same field names shown above (which exist in the 2016 version with the exact same names):
    The form field with name: "topmostSubform[0].Page1[0].EmployeeName[0].f1_002[0]" populates fine, just as it did before.
    However the checkbox form field with name: "topmostSubform[0].Page1[0].Line17[0].c1_011[0]" no longer populates, nor does any other checkbox.

    The 2016 checkboxes still accept "1" and "0" as valid inputs (as I can read the field values from a PDF form that I fill in manually) yet I can not get them to accept the data when filled via the VBA code. I'm not too experienced with PDF forms but it seems there is ultimately something different from the checkboxes in the 2016 form from the 2015 form.

    Any help or advice would be MUCH appreciated! Thank you!

    ------------------------------------------------------------------------------

    1095c 2015 PDF: https://www.irs.gov/pub/irs-prior/f1095c--2015.pdf
    1095c 2016 PDF: https://www.irs.gov/pub/irs-pdf/f1095c.pdf


    PDFTK Data Dump of checkbox field "topmostSubform[0].Page1[0].Line17[0].c1_011[0]" when unchecked:

    2015:
    ---
    FieldType: Button
    FieldName: topmostSubform[0].Page1[0].Line17[0].c1_011[0]
    FieldFlags: 0
    FieldJustification: Left
    FieldStateOption: 1
    FieldStateOption: Off
    ---


    2016:
    ---
    FieldType: Button
    FieldName: topmostSubform[0].Page1[0].Line17[0].c1_011[0]
    FieldFlags: 0
    FieldJustification: Left
    FieldStateOption: 1
    FieldStateOption: Off
    ---

    Windows 10
    Office 365

    NB: Title is ambiguous: The Issue didn't exist on the previous form (but the checkboxes did!)
    Last edited by MeleaB; 11-17-2016 at 08:20 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. User Form ListBox - Find Records (ListBox Populating Issue)
    By LONeillSSC in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 07-20-2015, 12:06 PM
  2. Issue populating values in User Form to proper cells on Sheet1
    By Grilleman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2015, 12:40 PM
  3. Protect the sheet but the form checkbox still can be change and sort by checkbox
    By carolyn1221 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-19-2014, 01:08 PM
  4. Replies: 0
    Last Post: 04-07-2014, 12:22 PM
  5. Trying to scale a form checkbox in a macro, don't know how to get checkbox name
    By tstruch in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2014, 12:14 AM
  6. populating data from another sheet using a checkbox.
    By Darkflame808 in forum Excel General
    Replies: 0
    Last Post: 10-31-2011, 02:22 AM
  7. checkbox on form reset from checkbox on sheet
    By raw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-03-2005, 01:15 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1