InfoPath Dev

You can use the EditDocument2 method on the SharePoint.OpenXMLDocuments.1 object described in Shraz's post to open XML files. http://msdn.microsoft.com/en-us/library/cc264018.aspx

Yes, we have 2003 & 2007 installed. All PCs should be set to open 2007 by default but some try to use 2003 and get an error.  Some even open the xml in the browser, and I assume if people install another xml program it will usurp the file extension (on my PC sometimes it opens in Visual Studio).  I need to know which registry ...

Hello, I use SQL code to fill in secondary connection fields. I get the values and I submit the form via Email. When receiver opens the form, they can see but empty fields. Where have these values from secondary connection disappeared? Do these secondary connections refresh automatically at some point? What is the best practice to get values ...

Glad to help, and I hope you figure out this last problem.  If you still can't get it after a while of troubleshooting, you can e-mail the form to me at james dot rishe at qdabra dot com, and I can have a look.

 Dear all,   I have a infopath form A (2007 version) with a button called Back.  Form A open when user click on a link from Search screen (Webpart) with a result data table. The requirement is that whenever click Back button from A form, it is moved back to Search screen that kept same status as before go to A form (similar when ...

Jimmy -- I just applied the formula to another section that is identical to the one I'm having the trouble with - there are 30 fields in it just like the other one; this one worked like a charm, confirming that the problem with that other section is unrelated to the formula. So, again, I want to say thank you very much.  ...

No problem that I know of, but I've never tried the formula with more than a few fields.

I just tried another section and the formula worked just fine.  There must be something else unusual in the section where I'm having trouble.  I will continue looking into that. There wouldn't be a problem with a large number of fields in the formula (like 30 or 50) as far as you know would there?  

The unchecked values do not have a space in them. Here's the formula: substring(eval(eval((AirTopicsHide1 | AuditDiscloseHide1 | BBEnvSeminarsHide1 | BankruptcyHide1)[. != ""], 'concat(", ", .)'), ".."), 3, 10000)

Is there any chance the checkboxes in that section have blank spaces in the unchecked value?  Could you post your formula?