InfoPath Dev

I'm getting an ''object doesn't support this property or method'' error now. Lisa Spencer Programmer/Office Specialist

I'm still working on it! var objDataObject; objDataObject = XDocument.DataObjects(''qryGetTicketNumber''); XDocument.DataObjects(''qryGetTicketNumber'').Query(); XDocument.DOM.selectSingleNode( ''/dfs:myFields/my:TicketNumber'' ).text = XDocument.DOM.selectSingleNode (''/dfs:myFields/dfs:dataFields/d:TicketData/@TicketNumber'' ).text; I'm ...

I have bought the ''Programming in Infopath'' book. It just takes so much time to read a book, I'm just trying to get this one automatic field done now. No, the error is when I am trying to set the variable to the last ticket number in the database. I am trying to reference the database. I have var lastTicketNumUsed = ...

Was that a hint not to ask anymore questions? LOL Do you know how to resolve the error? Lisa Spencer Programmer/Office Specialist

Can I do an XPath to the Expression box? Would it be something like this? /dfs:myFields/dfs:dataFields/d:qryGetTicketNumber/@FirstofTicketID I get an error-invalid location path.Thanks, Lisa Spencer Programmer/Office Specialist

Thanks for responding. My code is similar to your psuedo. I am getting an error ''undeclared reference to namespace prefix dfs'' I am unsure how to reference the data source and run the query properly. The data connection is a secondary data source. So I know I have to use Dataobjects. My code is: objDataObject = ...

You're right. I figured it out shortly after I posted! Thanks! Lisa Spencer Programmer/Office Specialist

Hi! I am trying to create an automatic number field that starts at 531. It's for a ticket support form. I need to program a text box field to increment everytime a new form is created, otherwise if a ticket is just opened not to do anything. I am using VBScript. The form is connected to an Access Database. Thanks, Lisa Spencer Programmer/Office ...

What's wrong with this code? function XDocument::OnLoad(eventObj) { If XDocument.IsNew Then Dim TicketNumber, HiddenText TicketNumber = Sum(HiddenText) + 1 End If } Error in Script.js expected ';' in Line 26(which is the If line). Thanks! Lisa Spencer Programmer/Office Specialist

What's wrong with this code? function XDocument::OnLoad(eventObj) { If XDocument.IsNew Then Dim TicketNumber, HiddenText TicketNumber = Sum(HiddenText) + 1 End If } Error in Script.js expected ';' in Line 26(which is the If line). Thanks! Lisa Spencer Programmer/Office Specialist