using OutputTo

[Jeffrey]

Is it possible to prompt the user to provide the file
name using the OutputTo action in a macro?

Thanks for your help,

Jeffrey

 

[fredg]

Is it possible to prompt the user to provide the file
name using the OutputTo action in a macro?

Thanks for your help,

Jeffrey

Couldn't you just look this up in access help?

Output File The file you want to output the data to, including the
full path. You can include the standard file name extension (.asp,
..htm or .html, .htx, .xls, .txt, .rtf, or .xml) for the output format
you select with the Output Format argument, but it's not required. If
you output to Internet Information Server or Active Server files,
Access will always create files with the standard .htx and .idc or
..asp file name extensions. If you output data access pages, Access
will always create files with .html file name extensions. If you leave
the Output File argument blank, Access prompts you for an output file
name.

 

[Van T. Dinh]

If you leave the "Output File" argument blank, Access will ask the user for
the full-path file name.

BTW, what I wrote is actually in the lower right pane of the Macro design
screen when you click on the "Output File" argument in the lower left pane.
It is also mentioned in Access Help.

Suggest you observe the Access interface a bit more as it often gives you
hints on what to do. Also, you should check Access Help as the first
resource.