InfoPath Dev

It's not that "it's not working" in InfoPath 2007; what you're describing is default behavior in InfoPath 2010! :-) In InfoPath 2010: If you click on a control it'll display that controls properties in the ribbon, at the top. You can click any of the options there to see further options for that field. Or you can right ...

So you have scope to use some jScript/Vbscript to initiate the query instead of default buttons and rules? In script you can modify the SQL query that is defined for a data connection 'dynamically' before calling the query - this would only retrieve the data you need.

If it's not just the one InfoPath form, then it's probably a SharePoint issue. Maybe some settings or permissions have changed recently, or a patch applied to the server? Anyway, it's worth a shot asking some SharePoint experts if you can get the same error in multiple sites using different InfoPath forms. Good luck.

Date fields in Infopath forms store their text as YYYY-MM-DD so you can use substring function to strip the first 4 characters.  As for the incrementing id to represent the count of previous appeals, unless you have a way of retrieving previous tally submissions made via the form (maybe via a secondary data connect? are you using SQL ...

You will have to modify your form, check the option to browser enable the form, then republish. Why are you unable to republish?

You can format the field values directly into the view of the form, much like you do when you have the questions text and provide a field for the user to fill in, you instead have the summary text with the values of the field placed accordingly in the layout. This doesn't require you to have extra fields or data structure to present the ...

Yep, modifying your form templates can sometimes be hit and miss for backwards compatibility with forms from the old versions. Drastic data structure changes can break the previous forms.  Your approach is exactly what I have tried in the past and I have been met with varying success/no success. Sometimes I've had to 'pad' ...

Not sure if its the same issue, but Infopath forms viewed in Infopath for me always scroll to put the first selectable control at the 'top' of the window. Try putting a 'dummy' button, very small at the top left of your view. When a view loads it will default focus to this control.

Can you perhaps provide some details on your SQL tables e.g. Table1, Field1, Field2   Table2, Field1 and any fields in each table which link them? Depending on the structure may impact on how you accomplish what you are trying to to in Infopath form layout.

You want a field in Infopath where seperate Rich Text fields can be displayed appended to each other? I cobbled an example method together for you and attached - hope it gives you some ideas. The method uses the fact that rich text fields/nodes contain XML (in XHTML format) themselves. Using standard XML methods I select these XHTML nodes from ...