G
Guest
Is it possible to print a SNP file from code? If so what is the code. I am
using Access 97.
using Access 97.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Alex Dybenko
Try to use ShellExecute with "print" operation argument
http://maug.pointltd.com/access/Queries/TipDetail.asp?TipID=5
http://maug.pointltd.com/access/Queries/TipDetail.asp?TipID=5
D
Duncan Bachen
Alex said:Try to use ShellExecute with "print" operation argument
http://maug.pointltd.com/access/Queries/TipDetail.asp?TipID=5
Why make this so complicated with using an API? Simply use
DoCmd.OutputTo. It can output a variety of formats, including SNP (You
need at least Access 97 SR-1 to support SNP)
docmd.OutputTo acOutputReport, "rptMyReport", acFormatSNP,
"C:\something.snp"
R
Rick Brandt
Duncan said:Why make this so complicated with using an API? Simply use
DoCmd.OutputTo. It can output a variety of formats, including SNP (You
need at least Access 97 SR-1 to support SNP)
docmd.OutputTo acOutputReport, "rptMyReport", acFormatSNP,
"C:\something.snp"
That will not "print" an existing SNP file which is I assume what the OP
wants to do. It will create a new one, but it will not print an existing
one.
G
Guest
The parameter acformatsnp gives an error. Any other advice?
R
Rick Brandt
SHIPP said:The parameter acformatsnp gives an error. Any other advice?
That constant was added in newer versions. If you are using Access 97 use
"Snapshot Format" (including the quotes).