InfoPath Dev

Hi, so how can I solve the problem of validation error in query fields?

Stupid quesiton, but why not just add a dropdown and ask the user to select the location?

Thanks, I'll ask someone to look at this tonight or tomorrow AM and get back to you.

Relink doesn't resave. For the promo props to show you need to resave. If you have >100 you can download and install DBXL and use it with the Doc Migration tool to do the resave of all the forms and then delete DBXL. :)

Hi Serenity, We have another tool that supports very complex queries. It's bundled in the DBXL Web service and you will need to install on the ShP server. Easy to use though and we have lots of documentation. Cheers!

Add a hidden Yes-No field to your repeating table called "ShowMe". Add a condition that checks that value. That should work for multiple rows. Just make sure you use xpath Current command to get the correct ShowMe field when you compare. For the contains stuff, I would just have a default value on your ShowMe that changes when the ...

Hi Phill, Yes, you can use the CAML method described on other sites or just download the free trial of qRules and set it up that way (less work and easy to change). We have lots of qRules customers who do this. Very simple. CAML can also be done but the technique is relatively brittle and fails if schema or views change.

yes and yes. contact Support if we can be of assistance.

Hi Dan, Well, most people use either a) a Web Service tied to SQL, or b) a SharePoint list tied to SQL via BCS. This is the first I have heard of the VBA approach. Why not just map your InfoPath form to the SharePoint list and use BCS to write it to SQL? The problem with Excel is that it's client side (the VBA won't run on the server so ...

Mapybe you could create a XSL-"tweaked" XTP that you drag-and-drop into all of your forms...