Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004

    Unanswered: using transferspreadsheet with parameter query?

    Is there a way to pass the parameter value for a stored parameter query when calling DoCmd.Transferspreadsheet(acExport, ...)

    If I put the query name as the argument in the transferspreadsheet call it pops up a window prompting the user to enter the value. The value, however, is supposed to be derived from a control on the form.

  2. #2
    Join Date
    Mar 2004
    In your parameter query (or a copy of it) replace the [Parameter] with


    this will pass what ever is on the form into the query and open or export it.

    Note: The form must be open when you run the query.

    Hope this helps

Posting Permissions

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