I have a form with a button on it and I also have 3 Queries. What I would like to have happen is—when the button is clicked, all 3 Queries get exported to 3 separate Excel Spreadsheets, as follows:
Querry1 goes to Spreadsheet1 located at C: /Matt/User/Desktop/Spreadsheet1
Querry2 goes to Spreadsheet2 C: /Matt/User/Desktop/Spreadsheet2
Querry3 goes to Spreadsheet3 C: /Matt/User/Desktop/Spreadsheet3
What I would like to happen is, when the button is clicked—each of these Queries get exported to their respective Spreadsheet.
Note: I would like to overwrite any data within those spreadsheets every time an export is performed without receiving a Warning Dialog Box.
Also, once the export is complete, I would like the Access Database to display an 'Ok' Dialog Box that simply says "Report Has Been Exported"
Does anyone have a code I can place within my button?