InfoPath Dev

I believe you must select what kind of a main dataconnection you have at the beginning of creating a template. If you start a template based on an XML file (or word document? never done that before) then the main data source/connection will be email/file based for submit rather than database. I don't think you can 'convert' it to a ...

Yeah, I've been having annoying issues with my form security and databases recently. To get this to work for me today I had to go into Control Panel > Internet Options > Security Tab > Select 'Local Intranet' > drag allowed level slider to the bottom.. I don't really recommend or think that you would have to do this in ...

Sorry for taking so long, I got caught with the over-zealous (but probably necessary) security restrictions which come with IE8 and above. Prevented me from querying my local .mdb database successfully. I'm assuming you have things working. Anyway, unzip the attachment somewhere, you'll need to go to design mode and reconnect the main ...

Are there many records in the database? If not, then you can probably continue using secondary data connections and employ some conditional formatting to get the results you are after.

No submit? So purely a display of records in the database. This means no new information will be expected to be added to the form and stored anywhere? Just checking because you need to be clear on which paths to take before proceeding, or you might end up having a messier solution down the track. The form *should* be blank when you open it ...

 great :-) That link is very good with the detail.

You say the data is selected through product number. Is the data in the database (all product numbers) quite large? This might imply to me that your query in the last form is not successfully retrieving/filtering for only the records matching the product number being queried. Instead it is retrieving ALL records, and THEN filtering via ...

Depending on how you've set up your datasource/tables in the database your description sounds like the workflow is like this: 1. Open form 2. Select customer name 3. Data from database will auto-populate 4. Add to list of allergies 5. Submit changes 6. Select another customer name 7. Data from database will auto-populate 8. Add to ...

Stop sprinting to the computer. You should be able to set up a secondary dataconnection connecting to the SQL database. The secondary datasource will have 2 sets of fields 'Query' fields and 'Data' fields.Find the employee Id field in the secondary datasource Query set and put that on your form as a control Add a button with a ...

 Which version of Infopath are you using? Can you use jScript or VBScript code? If so, then you could put code on a button to load the form xml data into an XMLDOM object with a .save function call which will do what you want.