InfoPath Dev

What is the error? What version of IP are you using? Are you using the 2007 object model or the 2003 object model? (look under Form Options, Programming, and see what the language is -- if you are using 2003, it will say so...)

I think that after changing your columns in SQL, you might have to 'refresh' your dataconnection in the form, so that the form 'knows' you now allow a longer number of characters. Have you tried selecting your main data connection in the Data Connections window, clicking 'Modify' and just walking through it again? Though ...

 Do anyone have any idea? I need to fix this asap.

Thank you for all you responses, unfortunately though none of the suggestions work.  I should mention that I am using a SQL2005 DB with InfoPath 2003.   I have set my column in the DB to NVARCHAR(MAX) don't have a datatype of NVARCHAR(256) limiting the box doesn't do anything.  I get the following error when ...

I do all my forms and workflows without code, so I can't tell you how to do it in VB, but what I can tell you is that if you are using browser-enabled forms, then the URL string that Forms Server provides when opening a form has an embedded URL at the end that tells the browser where to go upon closing the form.  It defaults to the view ...

You don't change the button settings.  You just change the label from "button" to "save" and then add rules by clicking the rules button.  Don't change it to a submit-type button.  This is where you put the rules to create the filename and do the submitting to data connections.

I appreciate the instructions. I am trying to follow your steps as written, but I'm still not getting it to work. Either I am misunderstanding your instructions, or they are written out of order and thus causing issues for me. I have created the "Filename" field and put in the rules, but I don't think I've got the rules in ...

Gayle, do you get the error code with max when doing the very first form in the library (or with no other forms currently in the library), or does it give you the error with forms already in there?  I ask that, because if there isn't a form in the library, then there are no ID#s to reference with the max function. Count and max are ...

i have a form that i am using simple rules on the submit button to reset values after submission to "". the problem is there is a repeating table, so if they add 10 items, it just resets all 10 items to "" instead of just resetting it back to 1 row.  is there a way to do this via simple rules or does code behind have to ...

Make a second "save" button next to your "submit" button on the form (not the built-in save/submit buttons on the toolbar, but rather custom buttons on the form). The Save button will just be a plain button that you rename and that has rules behind it.  Behind the Save button, add rules (no code) Create a ...