Results 1 to 2 of 2

Thread: Strange problem

  1. #1
    Join Date
    Aug 2004

    Unanswered: Strange problem

    I've got a DoCmd.OutputTo command within a macro.
    It's about the 8th procedure within the macro.
    For some reason the query the macro is supposed to output fails when the output is attempted.
    I have since tried this on another PC and it worked, does anyone have any ideas on what may be wrong on the other PC?

  2. #2
    Join Date
    Sep 2004
    Charlotte, NC
    Do you have access to the output path on both computers? If it is output to a network drive, do both computers have the same permissions to that drive? If it is output to a local path, does that path exist on both computers? If the output command is directing the output to D:\Data\transfer.xls and one of the computers does not have D:\Data, then the output will fail on that computer.

Posting Permissions

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