InfoPath Dev

I'm not sure what the relative path would be for this, or if this would work -- but I question the design decision. Do you really want a copy of the Access DB with the form? Then every user has their own DB? Wouldn't you want the DB on a network location instead?

You'll see from the MSDN link I referenced that: For secondary data sources, the WebServiceAdapter object is accessible through the QueryAdapter property of the DataObject object, and DataObject objects are accessible through the DataObjects property of the XDocument object. The code sample shows that you'd want: set dataObj = ...

Hello; This is an Infopath 2007 question.  I created a cascading dropdown in infopath using the ID of a secondary data source. The problem is I want the REAL data (not the ID) to post to my list.  Here is my setup & a bit more detail. I have a Secondary data source: Addresses I have 1 dropdown box called address and 3 ...

Using InfoPath 2010, I want to retrieve a value from an xml file based on the value of a field in my InfoPath form. I'm using this queried value to set a field value using a Rule on Form Load. This hard-coded XPath retrieves the desired value: xdXDocument:GetDOM("XmlFileName")//GroupB/NodeWithTextValue[@AttributeX='DDD'] In ...

I have found the exception is System.Runtime.InteropServices.COMException (0x800430D8): InfoPath cannot open the following file: http://.../eu-it/ARK/ARKDocuments/79.xml?util=openallforms. The selected file is an update of a form on your computer. However, the update has been blocked because the author of the file cannot be verified. If this file ...

Thanks Hilary, that was very informative.  I had no idea that these options were available. ****  set dataObj = XDocument.DataObjects("GetDatePlusDays") XDocument.UI.Alert( "DataObjects Connection: " & dataObj.WebServiceAdapter.Connection.Name ) **** The GetDatePlusDays is a webservice secondary ...

Hilary, Can I add a few days to a date in a date picker control using rules in InfoPath 2003 SP1 rather having to write code.  And can I have the result sent to another date picker control. Thanks Mel  

Hi and welcome -- It would be helpful to know what version of InfoPath you are using. For 2007 and above, you can right click a field or group in the data source task pane and select "Copy XPath" to get the XPath to a node. According to MSDN, the WebServiceAdapter has been with us since IP 2003. The line of code you get the error on ...

My system is Infopath 2003 SP1? Windows XP SP3 in conjuction with SharePoint; however I just now working with InfoPath separately.   It is difficult to find out what the XPath is for a control or dataObject input or output. I also noticed that some of the DataObject Adapters are not available.  When I try to use ...

Hi, I have a 2007 form which opens other 2007 forms from code.  I open the forms and submit them, to ensure that the OnFormOpen code gets run, and the data checked/updated on a regular basis.  Neither the starting form or the forms it opens are browser enabled. My starting form is published to SharePoint, and the forms it opens ...