Data Connections

Re: Word Print for InfoPath Form Connected to Access Database

Hilary Stoupa — Mon, 20 Jan 2025 23:11:57 GMT

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!

Re: Word Print for InfoPath Form Connected to Access Database

slendertech — Mon, 20 Jan 2025 22:57:44 GMT

Try this one.

Re: Word Print for InfoPath Form Connected to Access Database

Hilary Stoupa — Mon, 20 Jan 2025 22:52:51 GMT

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

Re: Word Print for InfoPath Form Connected to Access Database

slendertech — Mon, 20 Jan 2025 22:42:01 GMT

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.

Re: Word Print for InfoPath Form Connected to Access Database

Hilary Stoupa — Mon, 20 Jan 2025 22:30:07 GMT

Can you share a copy of your Word doc?

Re: Word Print for InfoPath Form Connected to Access Database

slendertech — Mon, 20 Jan 2025 22:24:09 GMT

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.

Re: Word Print for InfoPath Form Connected to Access Database

Hilary Stoupa — Mon, 20 Jan 2025 16:23:38 GMT

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?

Word Print for InfoPath Form Connected to Access Database

slendertech — Mon, 20 Jan 2025 16:05:06 GMT

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)?