Thank you all,
This is the kind of dialog I was looking for and received, thank you. I’ll roll up my sleeves, what is left of them and try it out. I’ll let you know, but it will be awhile. I just knew there had to be a way and that’s pretty cool!
Thanks again,
Kit
Kit K
Last Activity: Jun 22 '07, 02:50 PM
Joined: Jun 19 '07
Location:
-
-
Mary,
Cool, I can do that, here goes. . . .
. . . I would like to be able to export query results to Excel Workbook(s) with the Workbook’s name of a “Manager’s” name and distinct tabs of the “Supervisor’s” name reporting to that Manager.
One of the ways I found to do this, via sites like this, is to have a separate query for each Supervisor along with a “DoCmd.Transfer Spreadsheet”,...Leave a comment:
-
Export multiple queries to multiple sheets in excel
I'm new here and will admit right off the bat, most of this is above my head, but I like Access and learning the ticks of the trade so to speak. Here is one and I’m sure there is a way, but I’m stuck.
Below is triggered when a button is clicked in a form:
The “Employee” and “Manager” are replaced with the actual names, (A –...Code:DoCmd.TransferSpreadsheet 1, 8, "Employee", "C:\Manager.xls", True
No activity results to display
Leave a comment: