InfoPath Dev

I'am using infopath2007, and recently met a problem which is my customer ask me to implemet rich textbox autocomplete . after google for a long time, only got text box autocomplete... Is there any way that we can make this function? using programming infopath or settings?  

Unfortunately, I cannot even open the form....

Yes, it seems that's very likely the issue.  If you go into the form options, there should be an Remove Code button somewhere that will allow you to remove the code entirely.  Could you give that a try?

I solved the problem. I went to Tools->Options->Form Options->Offline, and unticked "Store data returned from quaries so it can be used in offline mode".

Morning Is it possible to create a 14 (rows) x 20 (columns) table, then populate all the fields, and hitting the submit button will have 14 rows written to your SQL database? I know you can create a repeating table, but I want the repeating table to automatically open 14 rows, with different default values in 2 of the columns, fill out the ...

Hi Hilary, thanks for your reply. It is when I want to open the form to fill it out.   I have the following assumption: I had code in the form that I primarily wanted to use. Then, I decided not to use it and deleted it in the script editor. Unforturnately, I marked the hole content of the script editor-window and deleted ...

Thank you Hilary for your response. It sounds like "Promote Property" is more practical in my case? Or perhaps easier? Coding is not really my thing, probably those are for more advance users. How do I Promote Properties on Infopath2003? I went to Forms options and I do not see any tab for doing this, could you advise?

This command isn't very sophisticated - it is just grabbing whatever your current command is and slapping the passed in Where clause on it, so you know. You seem to be missing a closing parenthesis, tho: You've got an open parenthesis before "Forecaster", but no closing. Try this: concat("ModifySqlQuery /dsname=Main ...

Actually it wasn't, but I see what you are saying, I did change the name to main unstead of main connection and now get this error message: The query cannot be run for the following DataObject: Main InfoPath cannot run the specified query. [0x80040E14][Microsoft OLE DB Provider for SQL Server] Incorrect syntax near ...

I have some  jQuery code to add values to a Choice field (select-option) inside a InfoPath Form in a InfoPath Form Web Path.  The code works fine if I run it from within the I.E. Developer Tools or FireBig inside FireFox, but the same code doesn't work when inside the Content Editor Web Part. I don’t see any JavaScript error that ...