output to file

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Write report to file code 6
Create SnapShot File on Deactivate. 2
Change the capiton of the Report 1
OutputTo issue 2
Report to RTF 1
Missing Text with RTF conversion 4
Problem with OutputTo data 7
E-MAIL TWO REPORTS THROUGH SAME COMMAND BUTTON 2

Top