InfoPath Dev

I want to perform an SQL look up on a large catelogue table help on an SQL Server and populate a repeating table. I've managed to use Query fields to populate datafields in my table, but each time I create a new row inthe table and repeat the query, the existing entry is cleared. How can i peroform a row by row query on this table and populate ...

Now why didn't I think of that! Many thanks... ;-)

I've seen ways to do this from MsAccess using VB, So I guess if your using VB it might be possible?

I have a set of four repeating tables, each referencing to a different xml data set. One one Table is visable using Conditional Formatting based on the selection of a drop down field. My problem is this works perfectly however the table headers remain visable even though the conditional formatting criteria has been met and the remainder of the ...

I have an SQL Database and I've managed to create some useful forms for pulling off reports in Infopath. I'd like to be able to retrieve data from my SQL Database make ammendments then submit changes to the database using an InfoPath form. I'm having difficulty in figuring out how this is done, any help would be much appreciated.

Ok Many thanks

Is there any way I can create a button and place some code behind it that opens the specified Print View in Print Preview mode?

Hi Shiraz, as you mentioned earlier i've found that if you place the code found athttp://www.infopathdev.com/forums/topic.asp?TOPIC_ID=2711 in your submit button, the view will appear in the body of the email whereas if you use the Submit method it does not, however it is possiblt to send the view with form errors using the code while Submit does ...

Thanks

One final question if I may. If I use the standard submit to email feature, the form will not allow an email submission if there is an error on the form, i.e. missing mandatory data, which is good. When using the above code behind a button, the code allows an incomplete form to be sent via email. Any way to enforce the mandatory data check when ...