InfoPath Form and Access Database

ashoke — Thu, 24 Feb 2011 18:25:52 GMT

Hi Everyone,

I am using InfoPath and Access combination for a project. It's working excellent and I'm very happy by its performance. In the input form there are about 1,000 nodes and in the output queries, there are about 5,000 formulas. Is it too much :). Everyday, my user's expectation is going high and high. The last thing was to programatically export output in Excel (Someone doesn't like to go to File > Export to > Web. It's too much for her). It's done as a static file name. Now I'm trying to make a dynamic filename taking inputs from of the query fields. Fingers crossed.

In one of the output forms, there are 7 views. Is there any way to export all the views in one multisheet Excel file where every sheet will be each form view.

Thanks in advance,

Ash

Code

InfoPath Form and Access Database