Choosing an Output To format

C

Carlee

Hi there,

Is it posible to enable the user to select the format type to export a data
set to. I have a report menu that, i want to offer the user the ability to
export a query dataset to a specific file format, namely, excel, word, csv or
rtf.

Suggestions?
 
R

Rick Brandt

Carlee said:
Hi there,

Is it posible to enable the user to select the format type to export a data
set to. I have a report menu that, i want to offer the user the ability to
export a query dataset to a specific file format, namely, excel, word, csv or
rtf.
Click to expand...

If you use...

DoCmd.OutputTo

....and don't supply an argument for the export format then the user is prompted
to choose one.
 
Top