InfoPath Dev

Good morning all. I have the following code, but I am coming up with an error in my FROM statement. Sub CTRL10_7_OnClick(eventObj) ' Submit Button Dim strSQL, MyConn ' Submit the form to add the new record Set MyConn = CreateObject("ADODB.Connection") MyConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents ...

Good afternoon. I have the following code: Public Function StoreFields() Dim Lockbox, Cash_Deposit_Date, Batch_Number Lockbox = XDocument.DOM.selectSingleNode("dfs:myFields/dfs:dataFields/d:tbl_GC100/@Lockbox").Text Cash_Deposit_Date = ...

Good morning. I struck out with JScript so now I am using VBScript. I have the following functions: Public Function StoreFields() Dim Lockbox, Cash_Deposit_Date, Batch_Number Lockbox=XDocument.DOM.selectSingleNode("dfs:myFields/my:Lockbox"); ...

Good morning.  I have a user form with about 50 fields. The data connections are several databases and submit through Outlook.  My problem is as follows: When a person submits a form, the information writes to the database, but if someone types over the fields, it writes over that record. I have to open a new form which clears out the ...

Good afternoon. I am new to InfoPath 2003 and this is what I am trying to accomplish: When a user complete the form, it is sent as an email attachment to several locations. It also submits the data to the main connection DB.  When a new record is created, the fields in the form are blanked out.  I want to save the fields as public ...