By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,475 Members | 954 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,475 IT Pros & Developers. It's quick & easy.

Access 97 - Transfer Text AcExportDelim - Too few parameters

P: 1
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...
Sep 2 '07 #1
Share this Question
Share on Google+
2 Replies


puppydogbuddy
Expert 100+
P: 1,923
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
Sep 2 '07 #2

jamjar
P: 50
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
Sep 25 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.