InfoPath Dev

You must use the VBscript DateDiff. If you search on it here you will find what you need and code samples.

Unfortunately InfoPath is only included in the enterprise version of Office. So it all depends on what you have licensed and deployed. If they all have Infopath that makes it simple. MOSS 2007 which requires IP 2007 to design the forms is the primary option. You can try Qdabra's Form Viewer for basic forms in a web page and it works with IP ...

I do not think you need the addin unless you want to just remotely execute. InfoPath and Query and submit data to and from Access on its own without Excel's help.

Also once you have the forms updating the data properly. All you need to do is publish the form to SharePoint. (Create the link to the template). That will be where others open the form initially. Can give them desktop shortcuts or whatever. Your Access DB would need to be in a shared location that everyone can access. (another nice thing for ...

Hey John.  Another option is using multiple InfoPath forms. You can have one to update projects but then have sub forms for your activities and milestones.  Sometimes this can give you some more flexibility. You can link from one form to another. The danger is modifying multiple parts at once. InfoPath checks data consistency before ...

You can automate some of the deployment and update of the data sources but either way you slice it is a modification. You could create a tool to probably make these bulk type changes. We use a tool which updates the URL's for our webservices dynamically. Publish to server A and the webservices are updated to point at server A Typically we ...

Hey Bob. I can show you some examples of how this can be done and what you need to do it. I think I can show you how this can be done a lot simpler and easier using web services. It removes all of the complexity out of the form so you only require a very small amount of code in the form. Send me an email and I can show you.

Hey Dave. My question is why? If you want the option of having a view read only. Create and finalize your view. Create a second view Copy and paste the controls to the second view In View properties make the view read only. Then just use a switch views action or in code if you need read-only. I do not think it is a dynamic process so I ...

Welcome Baron. You can setup a dataconnection to query the library where the forms are stored and check exisitng documents. The user can start a new form or open an existing form from the library. A new form creates a file name when it is submitted to Sharepoint initially, typically a concatenation of some fields.  When you open an exisitng ...

Welcome to the forum and the wonderful world of InfoPath. It would help to know what you are trying to accomplish. Is the data just manipulate din the DB or does the DB just source some information and the result needs to go somewhere else? I do not think you can really migrate this DB to SharePoint since SP cannot represnt relational data. it ...