Save a report as .snp

  • Thread starter Thread starter davea
  • Start date Start date
D

davea

Hi

I am trying to save a copy of a report as a .snp file using vb code
after it has been printed. I want to use a field (control) in the
report along with the current date as the name of the saved file so
that the user doesn't have to create the name by themselves

e.g. the code I'm trying to get should work like this:

DoCmd.Close acReport, rpt.Name, acSaveYes
'then save the report to C:/shared/temp/.. and name the file
[applicationnumber] & todays date

Any suggestions please?
 
Try this, a variation of what I have to do every day in my reporting.

DoCmd.OutputTo acOutputReport, "rptElapsed", acFormatSNP, c:\Report\ &
Format(Now(), "MMDDYYYY") & "_Month_MTD.snp"
 
Back
Top