InfoPath Dev

Dear InfoDev experts,  This forum has been a lifesaver! It is super-awesomeness and thank you to all who have contributed :)  Infopath/Access 2007 and lang: VbScript.  I want to be able to query the db to present only a selected amount of data on a different view. This will all happen when a user clicks a button. After all the ...

Hi Kalyan, InfoPath doesn't wrap text around images like Word does. You might be able to use calculated values to display a portion of a plain text field in two segments using substring, but that won't work for rich text and doesn't allow editing. You can add the image to the same control but then you won't be able to separate it ...

Hello, I have a pequliar issue: I have a form with 3 controls: controlA=username(),controlB=@EMPL_SURNAME[contains(@EMPL_EMAIL; ControlA)], which loads the values from a data connection and a controlC=@EMPL_SURNAME[contains(@EMPL_EMAIL; 'AStaticValue')] - i.e. the same with controB, but with static string in Infopath filler, all 3 ...

In the past when creating forms in MS Access, I was able to just write a macro with an append query that would append the values of the TaskID's into the Metrics table every time it was executed.  The macro would also execute an update pulling in a value from the form in use to get the current value of the DemographicID and ...

Hi Brian, It's because of the inexact version of HTML (InfoPath) to MHTML (what's used in Outlook). The Web mail form is probably just using HTML. There were numerous HTML to MHTML conversion issues back in 2003 when I worked on it and not all of these were not fixed in 2007 or 2010. My suggestion would be to play with the tables. Maybe ...

This site shows you how to check your installed certificates, you can get the expiration date as well. (it says Vista, but it works on XP) http://windows.microsoft.com/en-US/windows-vista/View-or-manage-your-certificates You can also check the exp date of the certificates when in InfoPath, Form Options -> Security -> when you ...

Hi Lyndsey, Qdabra Software has an XLS to XML tool that converts spreadsheets into XML. You have to have an InfoPath form template, but the data can be converted automatically. Works well in cases where you have lots of data.

Hi Steve, You can't filter SQL rowsets using a passed in parameter. InfoPath doesn't support passing query parameters to SQL. You can hardcode it in the SQL data connection and then use code to modify but as you say that's just not a great solution. We recommend using a Web service to do this. In fact, we developed DBXL back in 2005 ...

We have heard nothing from MS on this. My guess is that there will be no fix because you can install both VS 2008 and 2010. In other words, there is a workaround.

There are xpath functions for today() and now(). Go to Tools->Form Options->General and add a rule on open that checks those values in it's condition.