[AccessD] Snapshot question continued

This should work for you

    DoCmd.OutputTo _
            ObjectType:=acOutputReport, _
            ObjectName:="rptMyReport", _
            OutputFormat:=acFormatSNP, _
            OutputFile:="c:\myreport.snp"

John V. Ruff - The Eternal Optimist :-)
Always Looking For Contract Opportunities

Home: 253.588.2139
Cell: 253.307.2947
9306 Farwest Dr SW
Lakewood, WA 98498

"Commit to the Lord whatever you do,
                and your plans will succeed." Proverbs 16:3



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Monday, May 26, 2003 6:42 AM
To: AccessD
Subject: [AccessD] Snapshot question continued


I clicked Send too quickly. My second question is, can I save a report
to a snapshot without previewing it? I just want to create the SNP file
and attach it to an email. Since there could be 100 reports going out at
once, I certainly don't want to force the user to preview and close each
one in turn!

TIA,
Arthur

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com