Exporting Query to a text file

[denileigh]

I'm trying to export query results to a text file and it keeps giving me a "too few" parameters error. Can anyone help?

 

[JHB]

Without seeing you query, no, therefore show the query!
Mostly such errors are from misspelling fieldsname.

 

[denileigh]

Pat,

Thank you so much for your response! That may be my solution however, I'm not an expert access wiz. I can figure my way through it though if you can give me just a little more info. We are linked to a sql backend...does that help? How do I set the parameter values?

Thanks so much for you're help.

 

[pr2-eugin]

How about.. DAO Recordset with Parameters

Scroll down to the last sample..

 

[denileigh]

That is so over my head. *sigh* Where do I put that? I'm just pulling a couple fields from two table and need to export to a txt file? I usually just click external data and then txt

 

[klnlsu]

Denileigh,
In response to your question, no I haven't resolved my issue yet. My problem is I am using a query that requires input by the user and my VBA code doesn't like the way I am trying to use it as a recordset. That is why I am getting the "not enough parameters" error. Instead of using the query directly, I changed the query to a create table query and I am using the table in my VBA code instead. I didn't get any compiler errors, but I am still debugging other issues so I can't say whether or not I will get the results I am looking for yet.

 

[klnlsu]

Changing the query to a create table query and using the table instead of the query worked great for me. I would suggest you try that.