Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    47

    Unanswered: Exporting a query with a Textbox Criteria

    I am getting the following error when trying to export a query to CSV that has a textbox value from a form in the criteria:

    "To few parameters. Expected 2."

    From reading through earlier post, you can't export a parameter query so I understand that part.

    What is confusing me though is that I wasn't aware that using a textbox criteria was a parameter query. Is this true or is there some other problem happening here? The query runs fine without any prompts when not exporting.

    Does anyone know of any workarounds for this problem?

    Thank you!

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Could you make it a 2 step process. Step 1 - Change the query (with your parameters) to a make-table query. Step 2 - Export the newly created table. I do this quite often as it also gives me a solid table to look at and compare with against the exported data.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Jan 2006
    Posts
    47

    Thank you!

    This worked perfectly... Thank you!

Posting Permissions

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