build form to run queries

[krispetrie]

I have 5 queries I run daily. I would like to create a form that runs all 5 just by pushing a button (There will be fields on the form that supply values for the queries) I would also like the form to paste them into an EXCEL file for a non-ACCESS type person to manipulate. Each one should go to a different worksheet. I would like to automate this process as much as possible.

 

[Pat Hartman]

You don't seem to have a specific question. What you are trying to do will be relatively simple. You can use the TransferSpreadsheet Method to create the spreadsheets. The on click event of the button just needs to run 5 TransferSpreadsheet operations. It's as simple as that. The queries would refer to the form fields in their Where clauses to filter the data using the syntax:

Select ...
From ...
Where YourTableField = Forms!YourFormName!YourControlName;