-
There is a way to establish an Excel file to be XML/Schema based... and then you might be able to create a data connection to that file. I don't know all the ins-and-outs of it, but I'm sure someone does and has done it before.
Another possibility is this: If you have an Excel file with, say, 5 columns and X rows, and your InfoPath form ...
-
The problem is that the .text property ONLY gives text. That's why they named it that.
What you want is rich text, or XHTML. To display rich text, you need a rich text control.
To copy XHTML from one field to another, you cannot simpy use .text or you will get all the tags, etc., as you have already seen.
XHTML is a DOM. You must use code ...
-
The previous discussion was about setting an XHTML value. Are you asking about how to get just the text of an XHTML node? If you want just the text, and not all the nodes, just access the .text property.
-
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:
<TableName controlAccount="" budget="" element="" hours1="" hours2="" hours3=""/>
Repeating of course. Then a ...
-
Strange things are afoot at the Circle-K!
-
Once you understand them and their true power in the world of programming, you'll be using them all the time.
Good luck!
-
Yes - if you're anything like me, anything you want to do is always more complicated than you ever expected. Nothing is ever simple.
-
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 ...
-
Have you tried using Try/Catch statements?
-
Someone else can correct me, but so far as I know you will need both 1.1 and 2.0.