Search - InfoPath Dev Sign in | Join | Help InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads Search More Search Options Page 1 of 1 (10 items) Re: Which SQL Server data type to select? Hello, Never mind, after some more research, I tried NVARCHAR(4000), and it worked. Posted to SQL Database Integration (Forum) by Javiator on 02-25-2013 Which SQL Server data type to select? Hello, My InfoPath form is used to submit data to a table in a SQL Server database. I have a multi-line text box for the user to enter remarks, and would like to increase the maximum length to something above 255 characters (at least 2500 would be nice). I converted the appropriate column's data type from NVARCHAR(255) ... Posted to SQL Database Integration (Forum) by Javiator on 02-25-2013 How to allow for continual editing of records? Hello, I would like to set up my form so as to allow the user to progressively update records. This way, the user is able to submit as much information as is available at a given time, but may go back in and add or edit later, if desired. My form is connected to an Access 2007 database, and is laid out in a repeating table. ... Posted to Microsoft Access (Forum) by Javiator on 03-31-2011 Re: How to cause the value in a single control to be stored in multiple records? Hello, My error was in failing to enter the full XPath in the builder, while attempting to follow Hilary's examples. Here is the correct procedure: Go to the Data Source task pane Right-click on the appropriate node (for this example, the SessionID field) Select "Copy XPath." In the Tools menu, select Default ... Posted to Controls (Forum) by Javiator on 03-25-2011 Re: How to cause the value in a single control to be stored in multiple records? Hello, I clicked "Edit Xpath" and keyed in the syntax, but nothing has changed. When I click "Insert Item," the field is still blank in the added row. Posted to Controls (Forum) by Javiator on 03-15-2011 Re: How to cause the value in a single control to be stored in multiple records? I tested for the last question on my previous post, and found that the value is not being entered. Posted to Controls (Forum) by Javiator on 03-15-2011 Re: How to cause the value in a single control to be stored in multiple records? One more thing. When I manually key @tblOnlineTAP[1]/@SessionID into the builder, the formula is accepted, but my dropdown selection in the first row is apparently not repeated. I don't know if this would have any effect, but my control is populated by a query. The control is set to display a query field which concatenates ... Posted to Controls (Forum) by Javiator on 03-15-2011 Re: How to cause the value in a single control to be stored in multiple records? Hello, Sorry for the delayed response; I got pinned down by other assignments. Thanks so much for the sample, and the explanation. I think I would like to go with the "FieldA" strategy, but I'm having a good deal of difficulty with syntax. My actual object names are as follows: Group: tblOnlineTAP Field ... Posted to Controls (Forum) by Javiator on 03-15-2011 Re: How to cause the value in a single control to be stored in multiple records? Hello, Thank you for your response. I don't think I have articulated my problem very clearly, so I will try to do better this time. My form is laid out in a repeating table. Right now, there are two fields where the user will have to keep entering the same items repeatedly. That is to say, he or she will have to enter one ... Posted to Controls (Forum) by Javiator on 03-10-2011 How to cause the value in a single control to be stored in multiple records? Hello, First, I am very new to InfoPath. I am trying to design a form that contains several pieces of information for each person in a training session. My form is connected to an Access 2007 database. There are two fields in the table which will contain the same values for each record (person) in a common training class, and ... Posted to Controls (Forum) by Javiator on 03-10-2011 Page 1 of 1 (10 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.