output to file

M

mhmaid

how can i make this code to output my report diretly as snapshot file

DoCmd.OutputTo acReport, stDocName
 
S

SusanV

DoCmd.OutputTo acReport, "YourReport", "SnapshotFormat(*.snp)",
"YourReport.snp", True

Note the quotes around the report you are outputting and the output
filename. Also, the parameter True will open snapshot viewer, change to
False for silent output.
 
Top