Save as snapshot

D

Diarmuid

I'd like to add a button to my toolbar that would allow users to save a
report in snapshot format. How would I code this?
Thanks
Diarmuid
 
R

Rick Brandt

Diarmuid said:
I'd like to add a button to my toolbar that would allow users to save a
report in snapshot format. How would I code this?
Thanks
Diarmuid
Click to expand...

Look in Help for DoCmd.OutputTo. You would create a function that uses
that to create the Snapshot file and then call that function from your
toolbar button.
 
B

Billy Yao [MSFT]

Hi Diarmuid,

I learnt that you'd like to export a report in snapshot format via VBA coding.

I agree with Rick that you can use the OutputTo action to perform this task. The detailed code is as below
and I tested it successfully on the Catalog report of the Northwind database.

'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
DoCmd.OutputTo acReport, "Report_Name", "SnapshotFormat(*.snp)", "", False, ""
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

For more information, please see the following Knowledge Base (KB) article:

307184 How to Use Visual Basic for Applications to Export a Report in Snapshot Format
http://support.microsoft.com/?id=307184

Does this answer your question? Please feel free to let me know if this help solves your problem. If there is
anything more I can do to assist you, please feel free to post it in the group.

Best regards,

Billy Yao
Microsoft Online Support
 
D

Diarmuid

Thats great, thanks.
Diarmuid
"Billy Yao [MSFT]" said:
Hi Diarmuid,

I learnt that you'd like to export a report in snapshot format via VBA coding.

I agree with Rick that you can use the OutputTo action to perform this
Click to expand...
task. The detailed code is as below
and I tested it successfully on the Catalog report of the Northwind database.
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''''''''''''''''''''''''''''''''''
DoCmd.OutputTo acReport, "Report_Name", "SnapshotFormat(*.snp)", "", False, ""
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''''''''''''''''''''''''''''''''''

For more information, please see the following Knowledge Base (KB) article:

307184 How to Use Visual Basic for Applications to Export a Report in Snapshot Format
http://support.microsoft.com/?id=307184

Does this answer your question? Please feel free to let me know if this
Click to expand...
help solves your problem. If there is
 
Top