Snapshot for Export To in A97

  • Thread starter Thread starter Kahuna
  • Start date Start date
K

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
 
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.
 
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).
 
Back
Top