exporting objects from form

[Dylan Snyder]

I want to be able to export a query from Access via a button on a form.
I know how to use the transfer... to do it but I want it to run exactly the same for the user as if he or she had selected Export from the File Menu -e.g. the user is prompted for the save location

Does anyone know the code for this? Also, would it be possible to export an SQL generated query Or do I have to create the query in access?

 

[nIGHTmAYOR]

there is a macro for which called OutputTo check it out , as for sql if your needs are to create it dynamicaly then make your where condition use a dynamic parameter.