Greetings. New to Access (about 2 weeks) and I've run into a situation that I've been unable to find an answer to by searching. Please keep in mind that I'm still a little bit Access-illiterate but I'm working on that. :banghead: So any code that's commented out and idiot proof is greatly appreciated.
I need to export the results of a query to a comma delimited text document. I need this operation done with a button, not the data-export-text-wizard available on the ribbon.
---Info---
The query in question only generates two columns of data.
I would like the column headings included in the text document.
Text document File Name would include "query name" and date stamp format "mmddyyyy"
Ideally, explorer.exe would be called to open file save location in new window, however, I believe I can accomplish this task if you don't feel like adding the code for that. I did another button with this feature awhile back that I can probably gain insight from.
Thanks for any help or insight you have. Also, if I need to clarify anything please let me know.
I need to export the results of a query to a comma delimited text document. I need this operation done with a button, not the data-export-text-wizard available on the ribbon.
---Info---
The query in question only generates two columns of data.
I would like the column headings included in the text document.
Text document File Name would include "query name" and date stamp format "mmddyyyy"
Ideally, explorer.exe would be called to open file save location in new window, however, I believe I can accomplish this task if you don't feel like adding the code for that. I did another button with this feature awhile back that I can probably gain insight from.
Thanks for any help or insight you have. Also, if I need to clarify anything please let me know.