I have a couple of questions:



1) How would you programmatically create an Access snapshot report?



2) Is there a control (ActiveX or otherwise) that allows you to view an 

Access snapshot report without the view?



3) Somewhat related to #2, if there is no control - how would you then 

programmatically invoke the Snapshot viewer.



I am working on a project where the user will be generating time-sensitive 

letters and I would like to create a letter "archive" where they would be 

able to store and view the letters.  I would like to be able to view these 

snapshots from within a control, but if that's possible - how would I be 

able to invoke the Snapshot viewer?



Thanks in advance!



Vernon L. Vincent

Vernon



1. You would create the snapshot report by the following code:

Report_Name = the Name of the Report you want to create a snapshot file for.

Directory_To_Store_File = The directory where you want to store the snapshot

file to.

File_Name = the Name you want to give to the file.  You MUST include the

extension .snp



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

Directory_To_Store_File\File_Name.snp, False, ""



2. There is no ActiveX that I'm aware of.  You can copy the Snapshot Viewer

from Microsoft's web-site.  It is also on the MSOFFICE CDs.

You can download the Access 2000 viewer from

http://office.microsoft.com/downloads/2000/Snpvw90.aspx

The Access 97 viewer is located at

http://office.microsoft.com/downloads/9798/snpvw80.aspx



Once you download the program, install it.  It will be installed just like

any other program and you will have access to it via the Start > Programs

menu on your desktop.



3.  You would need to use the Shell Function.  Go to Help and search on

Shell.  As just stated above, you will be able to access the program from

Windows.



John Ruff - The Eternal Optimist :)





-----Original Message-----

From:	Vernon Vincent [mailto:vvincent@a...]

Sent:	Friday, May 04, 2001 3:25 PM

To:	Access

Subject:	[access] 3 Access Snapshot viewer questions



I have a couple of questions:



1) How would you programmatically create an Access snapshot report?



2) Is there a control (ActiveX or otherwise) that allows you to view an

Access snapshot report without the view?



3) Somewhat related to #2, if there is no control - how would you then

programmatically invoke the Snapshot viewer.



I am working on a project where the user will be generating time-sensitive

letters and I would like to create a letter "archive" where they would be

able to store and view the letters.  I would like to be able to view these

snapshots from within a control, but if that's possible - how would I be

able to invoke the Snapshot viewer?



Thanks in advance!



Vernon L. Vincent