Saving An On-Screen Report To A Snapshot File

[Wayne Aprato]

I've just spent about an hour reading posts on exporting reports as
snapshots but still can't find a solution to my exact problem.

If I am looking at a report in preview mode and want to click a custom
menu item and have that report (or any other report that I am viewing
at the time) export to a snapshot file, without having to stipulate
the snapshot format from a list, is it possible to do it with code?

I want to make it as simple as possible for the end user to save the
report as a snapshot file, and I don't want to burden them with
choosing the file format from a drop down list if it can be avoided.

Thanks in advance.

[Rick Brandt]

Re: Saving An On-Screen Report To A Snapshot File

"Wayne Aprato" <cqdigital@volc anomail.com> wrote in message
news:4d9a5a66.0 401301919.4f0e2 cc1@posting.goo gle.com...[color=blue]
> I've just spent about an hour reading posts on exporting reports as
> snapshots but still can't find a solution to my exact problem.
>
> If I am looking at a report in preview mode and want to click a custom
> menu item and have that report (or any other report that I am viewing
> at the time) export to a snapshot file, without having to stipulate
> the snapshot format from a list, is it possible to do it with code?
>
> I want to make it as simple as possible for the end user to save the
> report as a snapshot file, and I don't want to burden them with
> choosing the file format from a drop down list if it can be avoided.[/color]

Look in Help for...

DoCmd.OutputTo acOutputReport, "ReportName","S napshotFormat", "OutputPath "


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