Exporting query to text file

  • Thread starter Thread starter Marc
  • Start date Start date
M

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
 
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
 
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
Click to expand...
may have a typo error in an expression or
in a field name, or you use an alias where the use of an
Click to expand...
alias is not welcome (try replacing the
 
Back
Top