InfoPath Dev

Hello I am using a repeating table to collect data which is submitted to an Access database. One of the pieces of data I am collecting is a username, first name, last name, and date. What I would like to happen is for a user to enter each of these items once and for them to be included with each row...

Hello everybody, I'm trying to write a formula in one of the fields of a repeating table to mark the duplicate rows (the repeating table talks to a SQL table and has a foreign key constraint to another SQL table, not sure if that would matter in addressing the issue). Below 2 solutions look pretty...

I have built a form based on the database template and hope want to pull records based on two mutually exclusive fields. Basically I have a table that has a username and a contactname field which contain an employee identifier. In theory if the username field has a value then the contactname should be...

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...

I have an InfoPath 2007 form connected to an Access 2007 database, and yes, I started the IP template by telling it I wanted to connect to the Access DB. My Form has 3 pages: a query page where the user can see if their record exists or start a new record, and 2 pages for filling out the actual form...

Hi, I have two (main) fields in a repeating table. They are Product Number and Product Name. Their values are taken from my sql db. I want to keep their selections synchronized. So if someone selects a product number, it automatically fills in its corresponding name. And vice-versa: if someone chooses...

Hello Thank you for your prompt answer it helped me a lot. finaly this is what i did instead cloning each row For i = 0 To rows - 1 Dim myNamespace As String = NamespaceManager.LookupNamespace("my") Using writer As XmlWriter = MainDataSource.CreateNavigator().SelectSingleNode( _ "/dfs...

When I supply the row number directly it works great! But when I pass it a filter value it does not. I must have the wrong syntax. I will show you both ways I am trying it. This works... <xsf:calculatedField target="/dfs:myFields/dfs:dataFields/d:LaborSummary[2]/@NOW_ETC_HRS" expression...

I have been looking all over for the code to update a single entry in a database from a total value in a repeatable table. I can learn quickly given some good examples. is there a step by step method I can look at?

I would like to take to you about the Database Accelerator, but first I want to get my prototype to the users. All I need to do is update one field on an Access database from a total line on a repeatable table. Are you saying that I can do it by updating the manifest.xls file to get it to work? Should...