-
Hi --
I think you are going to manually need to add a filter to the target field for your rule. Please see this post by Jimmy and post back if you need further explanation.
-
The query method on the Document object failed.
InfoPath cannot run the specified query.
[0x80040E14][MSDataShape] Data shape command text contains a syntax error at or near 1066 command. The text near the error is: "[Comments_T]Where([Supplier_T].[strSupplierName]".
File: script.js
Line: 105
-
I'm not sure of a way to specify sending the form without the attached files, but I would think you could, in code, create variables to hold the contents of the nodes w/ the file attachments, set those variables to the values of the file attachment nodes, set the file attachment nodes to blank, send the email, then reset the file attachment ...
-
Given my level of programming skills, my recommendation would be to add in a number of MessageBox.show statements so you can see the value of the string strMySQLCommand. By doing this, you will be able to see that by appending the where clause at the end of the SQL statement is creating bad syntax. Add in the message boxes, ...
-
anyone else have any ideas on how to accomplis this?
-
Yes, page 2 of the second thread has code for doing this in JScript
http://www.infopathdev.com/forums/t/9471.aspx?PageIndex=2
-
My form is using jscript in IP 2003. Are there still options?
-
What error do you get when you use that code?
-
If you're willing to use code, there is a way to perform a custom query to get just the data you want. Please have a look at these threads for more information:
http://www.infopathdev.com/forums/p/9467/33496.aspx#33496
http://www.infopathdev.com/forums/t/9471.aspx?PageIndex=1
-
In a button's properties, you can click the fx button to tie the text on the button to the value of any field. Just create a field that's not shown on the form to store the value that will appear on the button. Then all you need to do is add a rule to the dropdown box to set that field to the necessary value whenever an item in the ...