var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Auto TransferSpreadsheet from report?
Have been searching for hours but cannot find a solution for my problem.
I have a query that performs calculations which are placed in a supreport footer.
I would like a way to automatically perform a TransferSpreadhseet of the dynaset each time this report is run. (A poor mans way of updating.)
Will the TransportSpreadheet automatically right over the prior TransportSpreadsheet?
Thanks . . . Rick
And the asnwer is . . .
Figuered it out.
This works great.
I have this in the report footer.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel2003, "qryBeachCitiesProg", "D:\flw\Access\", True
This resends the xport out (Updates) the file each time I run the report. I then link charts to it.
Hope it helps you.