InfoPath Dev

How do I read and parse (select single node....) the Infopath'07 XML (data only) files using MSXML2 and VBA? I seem to be able to navigate and load the XML from SharePoint form lib but get a load error "only one top level element is allowed in an XML document." Is it a valid XML file? The elements with no data are like: ...

Hillary, Wow! It works. My condition on the list that changes is DoorChanged is not equal to not(.)  and DoorChanged is not blank Set DoorUpgradeDate = Today() or Now() to better see the date changing when you change the dropdown list of door types ie. If you change to Now(), don't forget to change DoorUpadeDate to ...

Hillary you are great!  I'll try this and get back with you. One more question. What if my doors are repeating and a user can insert multiple doors. Do I place the DoorChangeDate as a repeating field to capture each door change. Say if I had 4 doors and 3 was changed on different days.

It worked- thanks! Also one mopre question. Are there hard size limits (or recommended limits) for files attached to forms using this control? Will the attachments affect the overall form library size limit?

I will make sure I am setting it on the right field- thanks!

Hello: First, if you don't already know this, do not check the "Cannot be Blank" button in the Properties dialog.  Instead, manually set validation rules and conditions that determine whether a control/field can or cannot be blank. Second, even if a control is not visible (hidden), it still is "present" on the form ...

Actually, checking for blank/not blank should do the trick (I just tried it).  The rule should be specified on the file attachment's field, not on the field you're trying to set.  Could that possibly be where you're going wrong? Also, please make sure that a formula for the default value of your yes/no field isn't ...

Hello: You need to set the rule on the field that is going to change. Given your example, you'd add the rule to the field that is bound to the Doors dropdown list. The rule would have an action to set a field's value. The field would be the DoorChangeDate field. Select the fx button next to the area where you can enter the value, and ...

My InfoPath form publishes to a Form Library in SharePoint and contains an "attach file" control. If a user attaches a file, I want the form library to display yes or no as a text value that can be promoted to the form library so that users will be able to see if one of the submitted forms includes an attached file or not. I ...