Open report snapshot file

[Al]

How do I open a snapshot file created from an Access 2000
report using VBA code within a command button to preview
the report. The file is stored in a folder on my
harddrive with a .snp extension.

TIA,
Al

 

[Steve Schapel]

Al,

What happens if you double-click on the file's icon in Windows
Explorer or some such. I would expect that the Microsoft Snapshot
Viewer was installed as part of your Office 2000 installation. If
not, you can download it (free) from...
http://www.microsoft.com/accessdev/articles/snapshot.htm?&gssnb=1

- Steve Schapel, Microsoft Access MVP

 

[Al]

Thanks Steve, but I already have the viewer, I just want
to know how to use VB to open the file from a command
button.
Thanks,
Al

 

[Rick Brandt]

Thanks Steve, but I already have the viewer, I just want
to know how to use VB to open the file from a command
button.
Thanks,
Al

Either Shell() or Application.FollowHyperlink will open it.