Access 97 - Transfer Text AcExportDelim - Too few parameters

[Pat Guy]

I am using a query as the source for the export.

One field is filtered based on the contents of a control on a form.

How do I get the TransferText acdelim to accept the selection criteria?

If I open up the query and do File export to External File etc I get too few parameters expected 1 and cannot open the Export Wizard..

Assistance would be appreciated...

[puppydogbuddy]

I am using a query as the source for the export.

One field is filtered based on the contents of a control on a form.

How do I get the TransferText acdelim to accept the selection criteria?

If I open up the query and do File export to External File etc I get too few parameters expected 1 and cannot open the Export Wizard..

Assistance would be appreciated...

Try declaring your parameter:
1.Place your query in design view.
2. Right click on the table area of your query that is not occupied by a table
3. On the shortcut menu, select parameters
4. Enter your parameter onto the dialog box in the following syntax:
Forms!YourForm!YourControl
5. Select the parameters data type (text, etc.)
6. click ok to save
7. Run your transfertext

[jamjar]

Try declaring your parameter:
1.Place your query in design view.
2. Right click on the table area of your query that is not occupied by a table
3. On the shortcut menu, select parameters
4. Enter your parameter onto the dialog box in the following syntax:
Forms!YourForm!YourControl
5. Select the parameters data type (text, etc.)
6. click ok to save
7. Run your transfertext

I'm running into the same problem, using Access 2002. Whether or nor I declare my parameters I can't run the Export Wizard until I delete them from my query completely.
Once I delete them I can run the wizard, create the specification, then add the parameters back to the query and run TransferText using that specification without any problems.

James