Save a report as .snp

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?
 
P

Pepper

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"
 
Top