Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    California
    Posts
    502

    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

  2. #2
    Join Date
    Mar 2004
    Location
    California
    Posts
    502

    And the asnwer is . . .

    Figuered it out.

    This works great.
    Code:
    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel2003, "qryBeachCitiesProg", "D:\flw\Access\", True
    I have this in the report footer.

    This resends the xport out (Updates) the file each time I run the report. I then link charts to it.

    Hope it helps you.

    Rick

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •