Print a Snp File

[Guest]

I have a command button that contains:
Dim stDocName As String

stDocName = "Not Completed JMC"
DoCmd.OpenReport stDocName, acNormal

It prints out a page, however I want to change that and print a SNP file and
also give the user a dialog box as to where the user would like to store/save
it.
Thanks

 

[Carl Rapson]

I have a command button that contains:
Dim stDocName As String

stDocName = "Not Completed JMC"
DoCmd.OpenReport stDocName, acNormal

It prints out a page, however I want to change that and print a SNP file
and
also give the user a dialog box as to where the user would like to
store/save
it.
Thanks

If you change acNormal to acPreview, the report will print in a window on
the screen. Users can then right-click on the report and choose Export...
and save the report as a .SNP file.

Carl Rapson