Choosing an Output To format

[Guest]

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?

 

[Rick Brandt]

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.

If you use...

DoCmd.OutputTo

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