InfoPath Dev

I always just check to see if the field is blank. Sure, that won't protect you if something goes wrong when the form is first created, but that's what error handling is for... Don't put any controls on the form that the user can change the info with, just use expression boxes for display. That way another user can't clear something ...

You'll probably find more than one way to do this, it seems to come up pretty often. In general, you could add a secondary data source to your SharePoint library to return the column where you are keeping these numbers, and get the max Id (use a substring-after formula to pull off the CR), add one, and stick the CR and the zeros back on. You ...

Hi: You'll need to filter the data for your @Product_Price field. You should probably use the Filter Data button when you select the @Product_Price field in the formula editor. You want to select the @Product_Price where the Product Name field from your secondary data source is equal to the main data source field that contains the seleted ...

Hi, welcome: As to question 1 -- I don't know of a way around the limitations of filtering in browser forms. I'm sorry. Here is an article on the InfoPath Team Blog for writing a web service to return filtered results. If you don't want to write a web service, we sell a very complete one here. If you aren't a programmer and this ...

 Let's say I have a repeating group called FruitBasket and an element called Apples under it. I would like to set up a data validation where if the sum of all apples in all the repeating sections > 10, then flag. I tried setting up the following expression: sum(/my:FruitBasket/my:Apples) > 10 However, it flags only on the input ...

PROBLEM: the forms have been all developed with InfoPath 2007.  Our Outlook licenses are for Outlook 2003. InfoPath 2007 insists on using Outlook 2007 and is ignoring our Outlook 2003.   When      Submit            is clicked,  the message is:          ...

Hi Anas, There are a lot of documentation available on the web. Here's a good article that talks about managing SQL server permissions. Hope that helps!

I have an Access 2003 database linked to Infopath 2003 and I have the following relationship.  Unit tbl has many Employees(EMP tbl). The Unit # is the Primary Key and the EMP tbl has the EMP # as the Primary Key and the Unit # as the Foreign Key. I have both tables linked in the InfoPath form. My question is the ...

Hi, Mark: I didn't want to leave this question as unanswered. As we resolved earlier today, the issue had to do with a rule that was setting the value of the field and some confusion as to what the field's actual value was. Not a SQL issue at all.