Article ID: 307184 - View products that this article applies to.
This article was previously published under Q307184
Moderate: Requires basic macro, coding, and interoperability skills.
This article shows you how to use Visual Basic for Applications (VBA) code to export a Microsoft Access report in Snapshot format.
With Microsoft Access 97 Service Release 1 and Microsoft Office 97 Service Release 1, you can save a static picture of a Microsoft Access report in an external file format (*.snp). You can then make the report available to users who do not have Microsoft Access installed on their computers. For example, you can send the report in e-mail or copy it to a user's hard disk. The user has to have only Microsoft Snapshot Viewer to view the report.
If you have Microsoft Access 97 Service Release 1 or Microsoft Office 97 Service Release 1 on compact disc (CD), you can find Snapshot Viewer at the following location on the CD:
ValuPack\AccessSnpvw80.exe is a self-extracting file that installs Snapshot Viewer. Double-click the Valupk8.hlp file on your CD (located in the ValuPack folder) for information about how to install ValuPack features, including Snapshot Viewer.
For an example of how to use Visual Basic for Applications to export a Microsoft Access report in Snapshot format, follow these steps:
CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.
Article ID: 307184 - Last Review: January 31, 2007 - Revision: 3.1