InfoPath Dev

Thanks again Patrick. For clarity, I am just connected to an Access 2007 Database and have no real knowlege of manipulating SQL databases or dealing with SQL Management Studio. I really am looking for simple and easy and something that does not cost much more time or money. The PartNumbersTable that I am trying to deal with is used by ...

 It worked,

I can think of at least two things: a) the name "c\" is not correct and doesn't resolve to a good file location, and b) you need to make sure your form's security setting is set to full trust to use this.

There is no timer event that will go back and check so the workflow must run based on some action (i.e. save or submit). I suppose you could create a workflow that iterates through the forms and checks the ones with status "Not Notified" and looks at their date fields. That sounds custom though or like something that requires a third ...

Formatting rules should be view-dependent. In other words, adding a formatting rule to one view should not affect it on another view. Another idea would be to add the controls to a section and set a formatting rule on that.

I am still struggling about the Security level. The form Security level selected: Domain, No signed certificate. After published the form to a network location. I can open the published form and populate data. But all of my co-workers in the same domain cannot open the form. The error message popup:  The form cannot be opened because either ...

Hi Caroline, I recommend changing it back to the way you had it but adding a condition at the beginning of your workflow that checks some value in the form (for example, a field called "Status") and exits out of the workflow if it's "Approved" or "Closed" or something like that. You can control the workflow by ...

Actually, it is on a Conditional Formatting

Hi Adam, You can definitely have separate Web service calls in one form. For SQL, the best practice is to not have a direct connection, but rather to use a Submit connection to a Web service. This may require redoing your form and writing a Web service or installing a generic one, like Qdabra's DBXL (an inexpensive option). We do this kind ...

thank you so much.  This is perfect.  Just what I needed.  Thank you for all your help.  :)