General

Re: Listing a column from an Access database horizontally accross an InfoPath form

Greg Collins — Tue, 11 Sep 2007 22:50:19 GMT

Sounds like your just getting 5 columns of a table which should be straight-forward.

If I understand your diagram correctly, your XML DOM might looks something like:

Repeating of course. Then a simple repeating table should give you what you want.

Re: Listing a column from an Access database horizontally accross an InfoPath form

m181354 — Thu, 06 Sep 2007 12:38:47 GMT

I have five columns in an Access table that need to be displayed on an Infopath page as follows....

Control Account

Date Date Date

Budget Element Hours Hours Hours

Budget Element Dollars Dollars Dollars

Is there a way to do this thru a SQL query?

Re: Listing a column from an Access database horizontally accross an InfoPath form

Greg Collins — Tue, 04 Sep 2007 17:58:47 GMT

There is no simple way to do this in InfoPath. InfoPath likes lists--not arrays, and can repeat list items vertically or horizontally. You might have luck creating your own ActiveX control to deal with arrays. I don't have any experience with custom controls, though I know they have limitations within InfoPath and that you should be able to find examples on the net somewhere.

If you want, you can contact Patrick Halstead directly about hiring his company (Qdabra Software) to build such a control (if it is possible -- which I cannot of myself say whether it is or not).

Re: Listing a column from an Access database horizontally accross an InfoPath form

m181354 — Tue, 04 Sep 2007 17:22:55 GMT

I have to format several columns of data from an Access table horizontally accross a page. The above option works for a couple of columns but not for all the ones I need. Is there a way to do it with arrays?

Re: Listing a column from an Access database horizontally accross an InfoPath form

Greg Collins — Fri, 31 Aug 2007 16:37:39 GMT

Since you are using IP03, there is no built-in way to do what you want. However, you can do some manual edits that will allow you to do this with a repeating section (not a repeating table).

Create a repeating section of a fixed width with two fields in it: Date on top, and Dollars below.
Then extract the form files to a folder (from the File menu), and close InfoPath.
Edit the view .xsl file and locate the new section you created. It will be in an xsl:template. There will be a <DIV/> tag set around the contents of that section. Change the DIV to a SPAN.
Save and exit your text editor.
Right-click the manifest.xsf file, and choose design.
If you had an XSN before, you can now save your template back as an XSN.

Listing a column from an Access database horizontally accross an InfoPath form

m181354 — Fri, 31 Aug 2007 16:21:25 GMT

I have a Data Source using an Access database and and need to display one of the columns horizontally across the InfoPath form. Do you have an example of how this can be done. The table contains 4 columns...Control Account, Budget Element, Date and Dollars. I need Date to be listed horizontally accross the page and Dollars to be listed under each date. I would like to do this using a repeating table.