InfoPath Dev

Hi, Is there an easier way than manually deleting unwanted/unused files from InfoPath after I extract files?  Basically, I know that I can decrease the size of the xsn file by deleting unwanted files, but the only way that I can seem to do it is by extracting the form and then going into the "Extracted" folder and manually deleting ...

I found it Jimmy. It was one of my custom ones.

Jimmy, Your decription on the various methods should be good enough.  I will take a shot at the methods above.  Thanks Jimmy for assisting me once again.  It is appreciated.

Good morning, I was wondering if there is anyway of determining what fields in the form have the status of required from the backend.  Basically, I have many fields in my form and I need to locate the field that I set as required at some point because I can't submit without clearing this setting on this field.  I simply have ...

Jimmy, I can't thank you enough for working with me on this.  It works nicely.  I think it you were closer, I would stop by and shake your hand.  Anyway, I have a lot of respect for you and everyone else in this forum that take the time to help users like myself while learning this product.  Thank you Jimmy.

 Jimmy, First thanks for taking the time on this.  I used the new code after I made my changes, but now some errors come up.  The first one is on line 43. The query cannot be run for the following DataObject: x InfoPath cannot run the specified query. [0x80040E14][Microsoft OLE DB Provider for SQL Server] Invalid column name ...

Wow, you are right on the "&". All the ones that I just tested have "&" in the fields.  How did you know by looking at the code that it was this character that was the issue?  Also, are there any other characters that u know might cause this type of an error? 

I appreciate it Jimmy.  I assume that when you say "It looks like this is happening when you have a DB field with an ampersand in it.", sometimes the values in one of the fields that I am pulling from SQL have "&" in it.  If this is the case, then yes, it would not surprise me that some of the fields values in the ...

Jimmy, It works most of the time like I said.  It is very helpful. Here is the code as it stands now.  I was trying to remove anything that I thought might be the cause so there are less blank lines in the code. With that said, the error line is at LINE: 87 and not 99 which was the line I had said in the orginial post.  ...

Hello, Can someone direct me in a fix for this?  I am getting this error when I click a button with code.  The error: "The following error occurred: Whitespace is not allowed at this location. File:script.js Line:99" The jscript code behind the button works most of the time, but the above error also occurs sometimes ...