Word Print for InfoPath Form Connected to Access Database - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Word Print for InfoPath Form Connected to Access Database

Last post 01-20-2025 03:11 PM by Hilary Stoupa. 7 replies.
Page 1 of 1 (8 items)
Sort Posts: Previous Next
  • 01-20-2025 08:05 AM

    Word Print for InfoPath Form Connected to Access Database

    I'm creating a form in InfoPath 2007 (yes, I know it's veeery old) for my dad's business that needs to utilize the Word print view functionality so I can print form responses to a very specific custom layout. I've been able to get a hold of the InfoPath 2003 SDK so I can use the InfoPath to Word Wizard to create an XSL file from a word document with my form template's XML schema attached.

    Here's where things get tricky. I created my form based on an Access database to allow for form responses to be submitted to the database (so he has a record of every customer he has worked with). Therefore, all the fields in the form correspond with fields in the database and are bound to them. The problem is that it seems InfoPath makes every field a Field (attribute) instead of a Field (element) when basing the form template off of a database. I also cannot seem to change this. Therefore, when I try to lay out where I want the information from filled forms when printed to appear within my word document, there is only one element titled "Order_Database" (the name of the table in the Access database that stores the order history) for me to position on the page that has many attributes (e.g. customer_name, order_date, address, phone, items).

    How am I supposed to lay out the document for printing when the form fields are attributes of "Order_Database" (I cannot position attributes all over a page)?



    Slender Tech
  • 01-20-2025 08:23 AM In reply to

    Re: Word Print for InfoPath Form Connected to Access Database

    I don't have an answer for the attributes situation in Word Print, but was wondering why not just use an Access Report or Form? Is it not possible to get the format you want that way?
    Hilary Stoupa

  • 01-20-2025 02:24 PM In reply to

    Re: Word Print for InfoPath Form Connected to Access Database

    Well, I didn't use an access form because I don't think the layout options are as paper-centric as word's are.

    In regards to the element versus attribute situation, I was able to create separate element fields that share values with the attribute fields, so I can now arrange them on the paper. The only thing is, I'm not quite sure how to. I'm going off of this old XML in Word tutorial, but I'm getting errors that seem silly.



    Slender Tech
  • 01-20-2025 02:30 PM In reply to

    Re: Word Print for InfoPath Form Connected to Access Database

    Can you share a copy of your Word doc?
    Hilary Stoupa

  • 01-20-2025 02:42 PM In reply to

    Re: Word Print for InfoPath Form Connected to Access Database

     I have included both the word document and the source files of my InfoPath form in case the schema doesn't show up by default in the document for whatever reason.

    Slender Tech
  • 01-20-2025 02:52 PM In reply to

    Re: Word Print for InfoPath Form Connected to Access Database

    How odd - the ZIP seems to be empty. It has a folder for XML in it, but no other files?
    Hilary Stoupa

  • 01-20-2025 02:57 PM In reply to

    Re: Word Print for InfoPath Form Connected to Access Database

     Try this one.

    Slender Tech
  • 01-20-2025 03:11 PM In reply to

    Re: Word Print for InfoPath Form Connected to Access Database

    Well, that one had the files, but sadly my version of Word is very recent and it removes the XML tags on open, so I can't repro the errors you are seeing! Sorry I can't be of more help!
    Hilary Stoupa

Page 1 of 1 (8 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.