Snapshot of a Report

[Bob Barnes]

I can print a SNP File from a Report and attach to an Email, like this..

DoCmd.OutputTo acReport, "LatestRecs", _
acFormatSNP, "C:\BobDev\ASNP.snp", False, ""

I know a Printed Report can be better formatting than a Printed Form.
However, I'd leke to have a "Print screen" of a Form, and make that a
SNP file. How can I do that similar to the DoCmd.OutputTo...above?

TIA - Bob

 

[Douglas J. Steele]

I can print a SNP File from a Report and attach to an Email, like this..

DoCmd.OutputTo acReport, "LatestRecs", _
acFormatSNP, "C:\BobDev\ASNP.snp", False, ""

I know a Printed Report can be better formatting than a Printed Form.
However, I'd leke to have a "Print screen" of a Form, and make that a
SNP file. How can I do that similar to the DoCmd.OutputTo...above?

As far as I know, it's not possible.

 

[Bob Barnes]

Oh No...As far as I know, it's not possible.

Sure, I can make a Report from the Record displayed on the Form, and attach
it, here, automated, in Lotus Notes..Outlook also.

Manually, an <Alt><PrintScreen> and <Ctrl><V> into Word or Excel works.
...but it has to be automated.

Thank you - Bob

 

[mcescher]

Oh No...As far as I know, it's not possible.

Sure, I can make a Report from the Record displayed on the Form, and attach
it, here, automated, in Lotus Notes..Outlook also.

Manually, an <Alt><PrintScreen> and <Ctrl><V> into Word or Excel works.
..but it has to be automated.

Thank you - Bob





- Show quoted text -

We know that it can be done by hand. Doug was talking about the
automation. It's very likely not possible.

Chris M.

 

[Bob Barnes]

I agree...and this MUST be automated.

There's a product called SnagIt..on http://www.techsmith.com/

We just used SnagIt to capture the Access Form w/ nothing in the Fields. W/
that, we made a JPG, which will be placed in an Access Report. We'll then
made a .snp and attach, automated, to a Lotus Note..of course Outlook will
also work.

The "negative", as we add/ delete/ move Controls to the Form..a new JPG will
be needed, but the Report Controls can be easily adjusted.

Thank you and Doug - Bob