InfoPath Dev

To put it more plainly: How do I prevent a query from running if a query field is blank or contains an invalid value? In the Run Query button properties, I have a rule that fires when the search criteria is blank or invalid. Now add an Action to send an error msg. This is working fine. But, after clicking OK on the msg dialog, InfoPath goes ahead ...

Hi Abhishek, Actually, I had performed your steps 3 times and still could not find the database option. I may have a problem with my install. I will attempt to reinstall and try again. Thanks for your advice, Mark quote:Originally posted by mshukla Mark, Lets go over this once more. - You open the infopath application. - On the initial ...

While filling out a form, when you click inside a section it will highlight the whole section and move your view to the top of the section. When you miss a checkbox and click just next to it the whole section changes color and your view moves. It's very annoying and is the biggest complaint I am getting from my users. The only solution I can come ...

i need to display some vertical text, however, when i insert a vertical label, the text is vertical in the wrong way, the bottom of the text is to teh left, and the top is to the right, i need the oppiste, bottom to the right and top to the left. any ideas?

Hi I have a question about the data that i am using in one of my forms. I have a large data sheet in a share point library and I mean large. I am using this information to populate fields on my form. The problem is that we have many forms open already (300+ forms) and the data on the spread sheet in share point needs to be updated often as ...

I designed a form and opened it in VS2005. I added a secondary data connection(SQL 2003). What I'm trying to do is this, when a person fills out this form they enter their SSN and then when they cliick a button, I want it to return their values like name, address, sex, ect. All those I have in a SQL table called social. Which I added as my ...

Yes, you should be able to do this in the Data Connections wizard. So, go to Tools -> Data Connections -> Add. Select receive data connection, then SharePoint, and then choose your form library. After this you will see a dialog box with the available columns and viola! I hope this helps!strSQLQuery

This is interesting code, Hilary. I've never seen the BuildSQLFromXMLNodes() function used. Instead of setting this one node to a blank, you could try removing the entire tree, maybe something like this: var queryFields = XDocument.DOM.selectNodes(''/dfs:myFields/dfs:queryFields//*''); queryFields.removeAll(); I haven't tried this, but I think ...

Not sure I understand your answer. I want only one billing address so why would I have multiple. I have many delivery addresses which are in are peating section and can be replicated many times. I want to select only one of the repeating delivery addreses to be copied into the single billing address. Does that make sense or am I missing something?

Do you also have multiple billing address fields? If so you should be able to change your XPath to copy over to the corresponding billing address section. If you only have one billing address section, how do you know which shipping address you want to copy?