Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DoCmd TransferSpreadsheet Help
I have code written to export 30+ queries to excel using the same date parameters. It runs and creates all of the export files but each file only contains the field headers and none of the data. I have included the code below. Please let me know if there is something I am missing. Private Sub...- pperilman
- Thread
- Replies: 6
- Forum: Microsoft: Access Modules (VBA Coding)
-
Export multiple queries to Excel
I have an access DB with over 30 quarterly reports that are run and sent out to different people at the company. each query is setup eaxactly the same way with slightly different parameters. There is also a prompt for starting transaction date and ending transaction date for each query. Is...- pperilman
- Thread
- Replies: 8
- Forum: Microsoft: Access Modules (VBA Coding)
