Exporting query to text file

[Marc]

Hi,
I have a select query that runs off of a form. One
parameter is selected in the form.
After I make the selection and run the query I would like
to export it to a text or csv file. When I try to do this
I get an error message that says "Too Few Parameters.
Expected 1".
Can you help?
I'm in Access 2000 on Windows 98.

Thanks,

Marc

 

[Michel Walsh]

Hi,


The query in itself runs fine (in data view)? If not, you may have a typo error in an expression or
in a field name, or you use an alias where the use of an alias is not welcome (try replacing the
alias by its primitive expression, if that is your scenario).

Is the form still open when you run the DoCmd.TransferXXXX ?


Hoping it may help,
Vanderghast, Access MVP

 

[Marc]

Hi,
Thanks for you suggestions. Yes, the query itself runs
fine. There are no aliases. The form was still open, but
when I tried to export after closing the form I still got
the same message.
Any other ideas?

Thanks,

Marc

-----Original Message-----
Hi,


The query in itself runs fine (in data view)? If not, you

may have a typo error in an expression or

in a field name, or you use an alias where the use of an

alias is not welcome (try replacing the