InfoPath Dev

Thank you for your quick response.  I changed my code but I am still getting the same error on line 98.  I have a semi-colon so I do not understand why I get the error on that line. InfoPath cannot open the selected form because of an error in the form's code. The following error occurred: Expected ...

I get the following error when I run the code below.  Does anyone see a problem with the code?  The line 98 already ends with ";" ERROR Form template: file:///C:\Documents%20and%20Settings\M181354\Desktop\PCAS%20Change%20Request%20Form.xsn InfoPath cannot open the selected form because of an error in the form's code. The ...

I need to sum a column that has a filter on a repeating table.  I know how to do it but I get the sum of all the rows instead of the filtered ones.  Is there a way to sum a column that has  filter on a repeating table?

The error appears when I add a new field to the SQL table and redo my data source to pick it up.  I start getting errors on form before I even attempt to add the new field to the form.  

I am getting red dashed errors on fields that worked fine before I added a new column on the SQL table and  re-did my Data Source.  The new field shows up fine under my Data Source but I get red dash errors on the form in different places.  Is it true that it is difficult to add new fields or make updates to fields when you ...

I have an InfoPath form created from a SQL Database Data source.  I need to make some updates/changes to the SQL tables but when I do I get an error on the form.  I re-do my data connection but I still get an error. I know I could use a Web Service or your Database Accelerator but I wanted to know if there was a way to make changes to to ...

I am running the below SQL Count function in Script.  How do I access the results?  I need to fix the statement in bold.   "select count(*)"; "from "; "[LaborSummary] as [LaborSummary] "; "where ([LaborSummary].PROGRAM = '" + programPrefix + "') and ...

I created a SQL query with a Group By clause using Toad for SQL Server.  It worked great. The query is below.  But when I run the query in InfoPath,  I get the error message below. Does that mean InfoPath does not support the Group By clause?  I could create a view but I need to pass in variables from the form. ...

I have a SQL statement with a Group By clause that get the following error:  The following error occurred: The query method on the Document object failed. InfoPath cannot run the specified query. No query fields have been generated because the specified SQL statement is too complex for InfoPath to parse. Does anyone know how to code a SQL ...

I am using InfoPath 2003 and have the following code to get user id.  var wshShell = new ActiveXObject("Wscript.Shell"); var wshEnv = wshShell.Environment("Process"); var username = wshEnv.Item("UserName");  But I get a popup that reads... An ActiveX control on the page might be unsafe to interact with ...