InfoPath Dev

I have an InfoPath form that is used to populate an MS SQL Server 2008 database. I have a Main Query which is used to submit data to the Database and there are also several Secondary Queries which are used to provide dropdown selections to the users on the form and I just populate the main table with the index values into the related tables like ...

Hello GemenZ, Sorry to hear you've been losing sleep over this matter.  It is possible to conditionally hide certain rows within a repeating section, but I'm not graspoing the logic you have at work here. For example, why would selecting 1 in the second dropdown cause section 2 to be hidden?  What's the logic behind ...

Hi Patrick, Thanks for your reply. Yes, I am using Infopath 2007 (Client) and its an Active X ctrl. No, I have not copied/previewed my form on my colleague machine but I have published form onto Sharepoint and tried opening that form on my colleagues machine clicking on New menu on Sharepoint List. But, it gave me error :(. You told to enable ...

Hi all, We have recently installed SharePoint 2011, using Infopath to do a lot of form development, will be doing all our reporting from SharePoint using our current database Postgres. Our problem at the moment is we cannot get InfoPath to connect to Postgres?. If anyone has ever been able to connect and get info from a postgres table and allow ...

Hi All I have eventually worked it out and stopped the values in the fields from changing.  It was all to do with groups and bindings.  I re-created the form from scratch and seems to be okay now.  NOTE:  I eventually used a repeating section. Thanks :)

Hi I have tried a repeating section and a repeating table but the issue I have is when I fill it is then click the link to insert another section or row (on repeating table), it has the same text as I have filled in in the previous section / row.  When I edit the text in the new section / row, it changes the text in the first section / ...

Why not just use InfoPath's built-in validation features?

We've had a bit of email back and forth on this and it seems the best plan for you may be to flatten your data source. I'm attaching a new simple sample form that uses conditional formatting to display things in the "grouped" manner I think you are looking for, as well as a qRules SortTable command. Give this sample a try, see ...

Hi clinter i recently stumbled across http://rindovincent.blogspot.com/p/vbscript-programs.html where there was a simple program to validate Numeric value in VBScript. I hope it will solve your problem just change the number in that program. It is very easy to understand and with the permission of that blog i am pasting that ...

Hi,  I have a doc that has the following fields: [Drop down list 1] - values 0, 1, 2 [Drop down list 2] - values 0, 1, 2 etc. [Repeating Section] - Field A - Field B I have total of 10 sections, let's say there names are 1, 2, .., 10. So, my repeating section place will look like this: [Repeating Section - 1] - Field A - Field ...