I have designed a switchboard which runs sql queries on a table.
I have placed 2 radio buttons on the form, the first says 'export' and the second 'save as query'.
If the user selects the 'export' button I want to export the query that has been run to excel and save the file to folder, c:\My documents.
If 'save as query' is selected I need to save the query generated in the current database.
Any help with any of this would be great!
I have placed 2 radio buttons on the form, the first says 'export' and the second 'save as query'.
If the user selects the 'export' button I want to export the query that has been run to excel and save the file to folder, c:\My documents.
If 'save as query' is selected I need to save the query generated in the current database.
Any help with any of this would be great!