Snapshot for Export To in A97

[Kahuna]

Hi Folks, I have two ways I print a report to Snapshot:

1. Send - where the Report options can be made between HTML, Excel, Dos txt,
Rich Text or Snapshot.

Problem: 'Send' adds the Report to an email, in Snapshot format, as an
attachment - when sometimes the user just wants to save the Report in
Snapshot - not mail it.

2. Save As / Export - where the user has the option to save the Report
Internally to the database or externally and then has the option to save it
as a Snapshot.

Problem: My app is secured and I don't want the user to have the option to
save to with-in the current database. Additionally the file is saved
with the Report Name (such as rpt_DWGReg etc), which is not very appropriate
for the end user.

Question: Is there a way to save a Report in Snapshot and avoid the 'Within
Current Database as' option?

Appreciate any feedback on this one.

Cheers

 

[Kahuna]

Spotted a post from earlier on a similar subject and tried their code
(jl5000)

Here's what I used:

DoCmd.OutputTo acOutputReport, DocName, acFormatSNP, "C:\" & gr_graph_desc &
".snp"

This works well enough, but the code does not default to the Snapshot
format - instead it gives the same options as the 'Send' method. At least it
does not attach it to an email though!

Any expansion on this would be appreciated.

 

[Kahuna]

Sorry Guys,

Found if I use: DoCmd.OutputTo acOutputReport, DocName, acFormatSNP

I can get the Output to Dialog up and the user can select their location for
the file (though the use can still select HTML etc etc).