InfoPath Dev

I too am trying to use an odbc connection to access MYOB lookup info,  I managed to use ODBC direct to set up a connection on the clearwater MYOB sample database, however, even though I could select the connect, infopath would not accept it.  I would also appreciate any help.

Hey Josh, That did it! Thank you!  & Thank you Hilary!  You have both helped me enormously! Regards - Phil

Okay Hilary, Tried your suggestion, at first it was not writing anything, however, I replaced [i] in the var blah line with 0 then 1 and yes it was writing the selected row accordingly.  I changed it back to [i] and its working!??  Thank you big time! I am hampered by my next step however,  I am trying to write a row of ...

Hi Hilary Thanks for your reply.  I still need further directions.  What do you mean by so: "my:AllocationDetails/my:PaymentMethod"? Appreciate your help Phil

Hi I want to get the value of a field for all records in a repeating table. In my current repeating table there are 3 records. I use the following code to try to retrieve the value of the field for each record but it only ever gets the value of the 1st record in the repeating table: var Records = ...

Hi Hilary, I'm happy to share the form with you, but it is not an easily stand alone form.  It has several data connections to form libraries on a sharepoint site along with calculated fields from those data connections. Nonetheless, I will forward it to you, I have doctored it a little for you to work with more easily.  If the ...

Hey Greg, Sorry for the delayed response, I have been acutely ill and bedridden. I tried without the double backslashes and it worked using the selectSingleNoe function! Now my challenge is the fill the text file in tab delimited format so it matches what the excel export produced. Regards - Phil

Hi Hilary, Sorry for the delayed response.  I have been acutely ill and bedridden. I have done all this.  This process works for me with a button, however, when I place the trigger field in the section on screen (same section that it lives in) and manually increment the number, I get an error with the same programming that was used for ...

You got it Hilary Regards - Phil

Update, I have solved the problem.  I had added a couple of attribute fields to the original form and forgotten to add them to the second form.  BTW the second form needs to have the signature groups/sub groups as per the original otherwise the merge will not happen. It is still annoying that even with the Digital Signatures option ...