Optional Fields in Infopath; Getting the xml node with VBA

Posted by Sunscreen on Stack Overflow See other posts from Stack Overflow or by Sunscreen
Published on 2010-04-12T08:49:44Z Indexed on 2010/04/12 8:53 UTC
Read the original article Hit count: 305

Filed under:

infopath

|

vba

|

Xml

|

xpath

Hi all,

I use vb to get data through my form. I have some optional fileds in my form and I have this problem with the following code:

MsgBox(myXPathNavigator.SelectSingleNode("/my:Status/my:Questions/my:Questions1", _ Me.NamespaceManager).IsNode.ToString)

When the optional filed 'Questions1' is inserted to the form I get the value 'true' by the IsNode function. If the field it is not inserted I have an exception,

stating that the reference is not correct (and it is indeed true). Is there a way to verify about a node, whether it is present or not in my form?

Thanks in advance,

Sun

© Stack Overflow or respective owner

Related posts about infopath

INFOPATH 2007 Copy XPATH Option, How i can get the Copy Xpath option in INFOPATH 2003

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi friends, I new for this Inopath, My quesion, InfoPath 2007 , I Can right click filed name i can get CopyXPATH, I Want CopyXPath function in INFOPATH 2003, HOW I Can get CopyXpath option Thanks >>> More
Saving a modified InfoPath form to its form library

as seen on Server Fault - Search for 'Server Fault'
Within our corporate SharePoint 2007 site, there is a particular form library that contains 10 separate files. 9 of these are either Excel, Word, or PowerPoint files and one of these is an InfoPath 2007 form that serves as a report. After noticing an error within this InfoPath form, I saved this… >>> More
Load InfoPath 2010 Forms & XSN Templates in .NET Web Applications

as seen on Dot net Slackers - Search for 'Dot net Slackers'
Aspose.Form for .NET now provides full support for InfoPath 2010 controls. Now it is possible to load InfoPath 2010 forms and XSN Templates in .NET Web Applications. Following is the list of InfoPath 2010 controls that are fully supported. Text Box … >>> More
Populate InfoPath Combo Box

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to populate a drop down and found this page, which provides part of the solution: http://www.bizsupportonline.net/infopath2007/programmatically-fill-populate-drop-down-list-box-infopath-2007.htm I got this to work, but if players.xml was changed, the drop down list didn't reflect it… >>> More
Creating a new Active Directory account with an InfoPath form

as seen on Server Fault - Search for 'Server Fault'
I am setting up a business partner portal in our Sharepoint server. There will be an AD group with permissions limited to viewing and possibly contributing to the specific business partner site and employees of our business partners will have accounts created for them as needed. Now we would like… >>> More

Related posts about vba

Tutoriel VBA/VB6 : Les extensions OpenGL en VBA et VB6, par Thierry Gasperment (Arkham46)

as seen on Developper.com - Search for 'Developper.com'
Bonjour à tous! Voici un article sur la programmation des extensions OpenGL, en VB6/VBA Cet article décrit l'utilisation de quelques extensions fréquemment utilisées : - Les VBO (vertex buffer objects) pour améliorer les performances - Les textures 3D pour réaliser des textures continue sur… >>> More
VBA : Obliger une saisie numérique dans une TextBox - Approche d'une résolution de besoin en VBA niv

as seen on Developper.com - Search for 'Developper.com'
Bonjour, Ci-dessous, le lien vers un nouveau tutoriel : « Approche d'une résolution de besoin en VBA - niveau débutant - Obliger une saisie numérique dans une TextBox » Le but de ce tutoriel est : De présenter une bonne approche de la résolution d'un problème simple en VBA. D'expliciter en… >>> More
Run VBA macro when condition is met

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello all, I'm creating a spreadsheet to train my numerical skills. Now, I use VBA macros to generate a new problem once the current one has been correctly solved. To do so, I still have to press a button in the worksheet, which costs time and is annoying. Is there a way that I can execute a… >>> More
Offset the tickmarks of a secondary axis

as seen on Super User - Search for 'Super User'
I would like to offset the tickmarks of a secondary axis in excel WITHOUT changing the minimum. Here is a very complicated VBA class that apparently solves the issue but I would like a solution that doesn't require me to construct my entire chart in VBA. Here is an example of what I mean (I removed… >>> More
Excel 2007 VBA macros don't work in Parallels

as seen on Super User - Search for 'Super User'
I've got a complex Excel spreadsheet I need to use at work. My colleagues use the spreadsheet on Windows PC's, with no special configuration required. I want to run it on a MacBook Pro running Snow Leopard. The spreadsheet contains VBA macros which connect to external Oracle db's over the Internet… >>> More