Print Snap (.snp) file later

G

Guest

I've got code which creates Snap (.snp) files from Access data via the
OutputTo command using the acFormatSNP format option. I want to print the
result from file later (e.g., "c:\My Documents\report.snp") rather than
executing the Access report again. What command(s) would I use?
 
K

Kahuna

That's Unreal Kit - just been pursuing the same thing myself and here's the
code I used:

DoCmd.OutputTo acOutputReport, DocName, "snapshot format", gr_graph_desc &
".snp"

Where DocName is the actual name of the report (i.e. rpt_DWG) and
gr_graph_desc is the view name of the report (i.e. Drawing Register).

This will save a copy of the report in snp format in the My Documents folder
on your computer.

Thanks to all for the help in getting this.
 
G

Guest

Isn't this fun?

Actually, I'd already created the file via the OutputTo command.

Now I want to open the .snp file in VB code and send it to print. I
explicitly don't want to run the Access report again, as data may have
changed and I want specifically the "snapshot" that was generated earlier. I
need the Windows-y code that would be equivalent to right-clicking on a .snp
file and selecting "Print".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top