InfoPath Dev

Jim?

Thoughts, help?

I am attempting to add a spreadsheet control (OWC 11) to a form, but I cannot figure out how to access the control's properties in VBScript code. My guess is that I need to bind it somehow and reference its properties through the data source, but it is unclear to me exactly how to bind this control. Essentially what I am trying to do is allow a ...

Does the data need to be converted to a different form before multiplying? ex: CInt(data)*num

I think I may have figured out a solution to the first problem...I use VBScript code to accomplish the task. Basically, the code is written into the OnAfterChange event of the drop down list box, so that it executes/updates every time a change is made to a drop down in any of rows of the repeating table. I use two data sources: First is the main ...

The layout table worked great. I used a 3 column layout table and then put the repeating tables in the first and third column (the second column just added a little space between the two). An easy concept, I should have thought of it myself. Thanks Pat!

I have a drop down list box in which the underlying value is a numeric ID# but the display value is a text string. I am using code to access the selection in the drop down list box as follows: myVar = XDocument.DOM.selectSingleNode(''//my:myFields/@my:dataFilter'').text This returns the numeric value however and I cant figure out how to capture ...

I have two repeating tables which I want to align side by side in a 2 column fashion. I am not able to do so. Any suggestions?

Task completed. The basic code I used to open and write to Excel from Infopath (using VBScript) is this: Dim objExcel Dim objNodeList Dim objNode Dim i Dim rowindex Set objExcel = CreateObject(''Excel.Application'') objExcel.workbooks.add objExcel.visible = true rowindex = 1 'Code below gets the data from the repeating table which is bound to ...

I created a group in the main data source with all the fields that my user would need for their input values. (The group looks much like the ones generated by the main data source because it has a repeating group under it with all the relevant fields) I then created a repeating table and binded it to the repeating group. I created a button that ...