Is it possible to print a SNP file from code? If so what is the code. I am
using Access 97.
--
M. Shipp

Try to use ShellExecute with "print" operation argument
http://maug.pointltd.com/access/Quer...il.asp?TipID=5

--
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com


"SHIPP" <(E-Mail Removed)> wrote in message
news:EE013FBD-492E-438C-A915-(E-Mail Removed)...
> Is it possible to print a SNP file from code? If so what is the code. I am
> using Access 97.
> --
> M. Shipp

Alex Dybenko wrote:
> Try to use ShellExecute with "print" operation argument
> http://maug.pointltd.com/access/Quer...il.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"

--
-D
Duncan Bachen
Director of I.T., Ole Hansen and Sons, Inc.

Duncan Bachen wrote:
> Alex Dybenko wrote:
>> Try to use ShellExecute with "print" operation argument
>> http://maug.pointltd.com/access/Quer...il.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"

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.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

The parameter acformatsnp gives an error. Any other advice?
--
M. Shipp


"Duncan Bachen" wrote:

> Alex Dybenko wrote:
> > Try to use ShellExecute with "print" operation argument
> > http://maug.pointltd.com/access/Quer...il.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"
>
> --
> -D
> Duncan Bachen
> Director of I.T., Ole Hansen and Sons, Inc.
>

SHIPP wrote:
> 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).

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com