InfoPath Dev

  Hillary, I liked your suggestion about adding the button to get the next available number from the database. The field in Access uses the data type of Number - Long Integer. So, I created my 'Get AssyNo'' button and added a rule that says "max(@AssyNo)+1". When I click the button, the word "NaN" ...

Yes, the main connection is to the Access DB. I set that up when I created the form originally. The main connection refers to tblBoard_Information which AssyNo is one of the fields. The AssyID is set for auto-increment in access but the AssyNo is typed in when using Access. Thatis why I want this number to automatically populate this field when ...

Hillary, Thank you for responding. I have verything working the way I want it to on my form. I have several xml files that I exported from Access 2003 and am using them as secondary connections to several fields in the query section of my form. I had linked to the xml files but decided it probably would be better to have the information embedded ...

Hillary, I continue to have the same problem as before. I have checked my secondary connection and it is set to receive data. In the Drop-down list properties, I have selected my secondary connection in the Data Connection box. In the entries box, I have selected the top level of the connection which is referring to another table in the db. ...

I have an IP2003 form with a main data connection uploaded to a SharePoint Form Library. When a person opens the form locally, is there any way to prevent a second person from: a) opening the form to their local machine in which case, an alert message should indicate that the form is already open, b) allow the form to be open but have the ...

After I got home from work last night, I was looking at my Sharepoint 2007 book and it gave me the answer I was looking for. Duh. Why didn't I read the book in the first place. Sorry for any inconvenience.

I have an IP 2003 form with a main connection to an Access 2003 DB. I am trying to publish this form to a SharePoint Form or Document library. When I publish the form, everything publishes fine but when I got to the SharePoint site and click new, I get the following error message. "The document could not be created. The required application ...

How did you figure this out? I have a similar problem.  Thanks

I have a form connected to an access database. I have drop-down lists in the query portion and in the data entry portion of my form. I setup a secondary connection for receive data for the query portion and when I try to link the drop-down list I get the following error: "You selected the field where the control saves data. Instead, ...

Patrick,   I am still having trouble with this. I have search the forum but wasn't able to find what i was looking for. I have an existing access 2003 db and have my infopath 2003 form linked to the backend of my db. I also have secondary connections for receiving data from 2 other tables in the same db. From the main connection, I am ...