InfoPath Dev

Hi friends,  I have the below code that runs for my submit that is running off of a button.  Does anyone know how to (what to) put to stop this from running and give an error message if the form is open as read only?  I am getting row update errors if someone trys to submit it as read only, there ends up being a ...

Ok, I guess this needs more information now that I go back and read it.  The user is updating 6 dates, she updates many customers at one time so we built a query in the database and she is updating that "spreadsheet" view in the database.  However, I need that information to feed back to the form once she has made her ...

Hi guys, I have a form that is attached to database on the backend.  We are trying to make an more efficient way for the user to update a task by her pulling it up in a query and puttiing in the bulk date.  What I need is the next time the form is opened for that date to pull into that field on the form.  Is there a way to make ...

Good Morning,  After two months to have time to work on this, I finally got it.  The code is: function CTRL2114_7::OnClick(eventObj) { try { XDocument.QueryAdapter.Timeout=240; XDocument.QueryAdapter.Submit(); XDocument.DataAdapters["MainConnection"] XDocument.DataAdapters["Submit"] .Submit(); ...

Good Morning,  I have finally got it working with the code below.  Thanks for all your help! function CTRL2114_7::OnClick(eventObj) { try { XDocument.QueryAdapter.Timeout=240; XDocument.QueryAdapter.Submit(); XDocument.DataAdapters["MainConnection"] XDocument.DataAdapters["Submit"] .Submit(); ...

Hi,  Thank you for responding, We are having network problems and have many remote users so they were getting timeout error.  I was told the only way to correct this was with code to change the timeout setting on submit.  Our SharePoint adminstrators would not budge on changing it on their level.   When I tried ...

OK, this code gets it to go to both connections, but it comes up and says it failed.  So I still need that sucess fail code I guess, any ideas?  XDocument.QueryAdapter.Timeout=120; XDocument.QueryAdapter.Submit(); XDocument.DataAdapters["MainConnection"] XDocument.DataAdapters["Submit"] .Submit();  

Ok Guys, getting closer...  I have the submit working, now I need to get it to close the form and give a success/failure message... HELP.. XDocument.QueryAdapter.Timeout=120; XDocument.QueryAdapter.Submit(); XDocument.DataAdapters["Submit"].Submit(); XDocument.UI.Alert("The form was submitted successfully.");  

Hi guys, I am still struggling with a timeout error due to a slow network on my 2003 form.  I have come up with the below code (never written code in Jscript before) and now I am getting an error, Data Connection not defined.  Can anyone tell me what lines I am missing? XDocument.QueryAdapter.Timeout=120; ...

That was perfect, thank you so much!!