saving a report as SNP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

DoCmd.OutputTo acOutputReport, stDocName, "snapshot format", "OpenRMAAging" &
Date & ".snp"

I am Atempting to save a reprt as a .snp file an what I would like to do is
save it with todays date. It works, however, it puts the slashes in and that
doesnt play well with windows. How can I use the date to stamp the file.

also

If I use the full path \\servername\dira\dirb\"OpenRMAAging" & Datein
correct format & ".snp", will it just write it to that directory?
 
NNlogistics said:
DoCmd.OutputTo acOutputReport, stDocName, "snapshot format",
"OpenRMAAging" & Date & ".snp"

I am Atempting to save a reprt as a .snp file an what I would like to
do is save it with todays date. It works, however, it puts the
slashes in and that doesnt play well with windows. How can I use the
date to stamp the file.

also

If I use the full path \\servername\dira\dirb\"OpenRMAAging" & Datein
correct format & ".snp", will it just write it to that directory?
Click to expand...

DoCmd.OutputTo acOutputReport, stDocName, "snapshot format", "OpenRMAAging"
& Format(Date,"yyyy-mm-dd") & ".snp"
 
Back
Top