InfoPath Dev

Hi Clay, can you advise how to calculate difference between days including start date and end date? Example, start date 01/03/2014 end date 03/03/2014. Number of days should be 3.  With this solution, difference days is 2. Thank you very much.

Hi, when using this formula to calculate difference between dates, example 01/03/2013 to 03/03/2014 formula calculates 2 days, acctually difference is + days. Can you please advice where add +1 day in the formula or to change the logic of calculation? Thank you

Hi Experts, I created an InfoPath 2010 form that allows users to add file attachment and submit to a Forms Library. It submitted successfull without any errors. However, when reviewing details from the forms Library, that column/field is not visible. Please advise how I can make this field visible. I am just wondering where the ...

Hi - I have the expression [not(. = preceding::*)] to eliminate duplicates in a list of values in an infopath form, based on the recommendation from this thread:   http://www.infopathdev.com/forums/p/17807/62070.aspx It works perfectly in the Infopath Filler client, however it seems to be incompatible with browser forms, since I get an ...

How I can refresh database every time after user fill the form? i made validation to the text field that won't allow duplication. but the problem is the user still can input the same thing that already exist in database. the duplication can be avoided after i refresh the database manually. can someone suggest me solution?

Yup, just click Ignore and IP should use the compiled DLL that is in the form's source files. If you ever need to see what is in the code file, try a decompiler like IlSpy - that will let you recreate the code if needed.

Hi Pascal, We have a Web service called DBXL that you can use to quickly parameterize and filter queries to a SQL database. The query string is data driven which means you have one Web method for all queries reducing the complexity of your form's data connections. In addition, you can update this query dynamically to requery on the fly. The ...

A coworker asked me to modify a couple of dropdowns in a SharePoint-published InfoPath file. I used SharePoint Designer to open the template in design mode and made the changes, but when I went to quick publish the template, InfoPath prompted me that the Visual Basic project file could not be found. The project file is long gone--lost to a ...

Hi there, I am working for a charity and we are trying to setup a collection/delivery form of donations/purchases for our van. The data taken on the form includes name/address/items to collect/deliver and also Date and time of delivery/collection. Currently, on submit, the form is emailed to a central email address which has email forwarding to 3 ...

Nothing in the logs that can give me a clue.