Ability to list all queries on a form then output them to Excel. MS Access 2003
Posted on 2011-02-24
I have a database with 75+ queries in which people run on a day to day basis, the majority of these people copy the results into Excel and then work on them.
I am trying to automate the process a bit and create a form which lists all these queries (in the 'Detail' bit of a form) and then have a button next to each of the query names which will export the query results into Excel, saving the file to C:/ and naing it the same name as the query.
Is this possible from MS Access? Will I have to have a table with all the query names in it or is there someway of picking up all the queries on the form?