InfoPath Dev

InfoPath has limitations when creating direct connections to a database: http://office.microsoft.com/en-us/infopath/HP100950831033.aspx Quoting the article (I've underlined memo): None of the data fields in the main data source of the form store a large binary data type  InfoPath will disable the submit data connection if the ...

 Can you make access memo fields (memo - data type) work with InfoPath 2003? Seems like it is limited to text box constraints (256 characters) , but I gotta believe I am just missing how to get them to work togather because I can not imagine a product like this being this limited (even in its first version) Thanks for ...

One more point is now I am working on InfoPath 2007.

   Hi, I tried to write one of the following lines, but the intellisense is not popping up. Application.XDocuments.Close(XDocument) Application.XDocuments.Close(0) XDocument.View.Window.Close(true); thisApplication.ActiveWindow.Close(true); I have added the reference to "Microsoft.Office.Interop.InfoPath.dll" to my ...

Here is a blog post that addresses your issue: http://www.infopathdev.com/blogs/david/archive/2007/08/29/showing-custom-modal-dialogs-in-managed-code.aspx It contains a link to source code for the custom message box winform.

Yah that is why you want a web service so that you can query the data instead of loading all of it each time.  if you can only load the fields you need in your data connection that could help some too.

Thanks Clay, the filter worked and the data validation works now. Now the problem is the secondary source contains 80K records and it searches until it finds (or doesn't find). So my performance sucks, but I'll have to figure a work around for that

I found a bit of a work around. I put a rule on my submit button that when submitted instead of closing the form as i did previously. I just switched the view to a view that said i have successfully  submitted my form. Thanks for the help

This is really interesting.  I've uploaded a form into a common library and I and my client uses that same one.  Here is the issue that he is having but I'm not: .  I've saved a testing form and I can re-open it just fine.  But he sometimes gets an error like "There has been an error while opening the ...