InfoPath Dev

Hi, I have one repeating table and it is populate from sql data using a web service. In this repeating table I've several fields and 2 of them are text box with "time" data type. When the table is populate, these 2 "time fields" apears in "red", like it had invalid data. If I, in the browser, delete ...

[quote user="Hilary Stoupa"] Well, and that is part of the problem with the 'New Record' button -- can't add any other actions to it. But, in general, you can add either a field to your main data source or add a secondary data connection to an XML file and then set a value in that field that you can base your conditional ...

Can u provide some code for doing this? I mean for adding "switch on another new after clicking a New Record button"?.

I created a repeating table for the master table. And a separate section for each other table within the repeating section. As I didn't have to intermix the data in the subordinate tables on the form, everything should be okay. Thanks all for your help.

Hi Anuma, I think your method in the link is a bit complicated. Because you are trying to analyse the months individually, and the days also. It is not necessary. The best solution is to convert the whole date to a decimal value, deduct one date from the other and find the whole integer part of that number. As in the formula I was ...

Hi, Can you verify this link. http://www.bizsupportonline.net/infopath2003/calculating-age-from-date-of-birth-infopath-rules-formulas.htm

Hi Patrick, Thanks for the response, I appreciate your help. I have not changed schema to cause this issue,  I am still in development /test mode, for this I followed following steps - 1. Create table (T1) with two columns 2. Create a view (V1) to select recods from T1  (I need to use view because ...

Hi, I am trying to calculate the  age of a person, the field name is cust_dob the formulae I used,     I copied and modified from posts on calculating age,                     in an expression box is floor(  (   ...

Hi  Can anyone assist me on how to be able to count the amount of times a certain name appears on a form that was selected from a drop down box.  A form contains a drop down box with a list of names.  This appears in a repeating table and a group of users use the same form but have to select their name depicting who made that ...

Thanks Anuma, I will give it a try. Sorry for the late reply, I have got a few issues I am trying to sort out.  I don't quite understand how it will work though. On a note, I think I have a very large form, over 190 Access fields, and many more InfoPath controls. So I have a an Entry form, a Print View form, and now you say ...