InfoPath Dev

Hi, To loop through your repeating table, you can use (group2 is the repeating group): Dim oNodeList As IXMLDOMNodeList Dim oNode As IXMLDOMNode Dim oField As IXMLDOMNode oNodeList = thisXDocument.DOM.selectNodes(''my:myFields/my:group1/my:group2'') If (oNodeList.length > 0) Then ...

Hi, Use something around: bool b = true; string sTemp = oNode.nodeName; while (b) { oNode = oNode.parentNode; if (oNode != null) {sTemp = oNode.nodeName + ''/'' + sTemp;} else {b=false;} } Regards, Franck Dauché InfoPathDev

Hi, Try: IXMLDOMNodeList oNodes = thisXDocument.DOM.selectNodes(''/my:PR_Form/my:Executers/my:Approvers/my:Approver''); foreach (IXMLDOMNode oNode in oNodes) { oNode.parentNode.removeChild(oNode); } Regards, Franck Dauché InfoPathDev

Hi David, Did you try: thisXDocument.View.Window.Close(true); just for the sake of it? Regards, Franck Dauché InfoPathDev

You are Welcome! Good luck. Regards, Franck Dauché InfoPathDev

Hi David, Did you try: thisApplication.ActiveWindow.Close(true); Regards, Franck Dauché InfoPathDev

If your DB doesn't have the default security settings, it would. Access security has nothing to do with your permissions on the machine, right? Did you try to create that empty DB on your machine, just to make sure. Regards, Franck Dauché InfoPathDev

Adam, Did you try with a schema built in IP? IP won't overwrite that for sure. If you are using XMLSpy an IP is overwriting things, you have a prefix/Namespace issue. Regards, Franck Dauché InfoPathDev

OK, did you try with a new fresh simple Access 2003 DB (no password). It looks like the error message changed: Security.SecurityException. I bet everything is now OK, but your connection string doesn't work because you need to add info to open the GA10605 DB. User may not be Admin, pwd may have been set, etc. Regards, Franck Dauché InfoPathDev

Yes, I would do as Matt explained. Make sure the Namespaces are the same, it would fail for sure otherwise. Regards, Franck Dauché InfoPathDev