Export Access Report (multiple pages) into Powerpoint

[ellenh]

I have read postings on the similar subject including the posting from
2003 shown below. This process works fine to display a single page
snapshot report in PowerPoint. I need to display subsequent pages from
the same snapshot file in subsequent slides in PowerPoint. I realize
that it is possible to add VB code to the Snapshot Viewer Control and
that there are properties such as .FirstPage, .NextPage, .LastPage,
etc, But I can't find any examples of actual code to write to move to
a subsequent page in the Snapshot file.

Thanks for your help!

From: evilhanz - view profile
Date: Wed, Jul 9 2003 12:13 pm
Email: [e-mail] (evilhanz)

To add an Access report to PowerPoint:

1. In Access, open your report. Choose "File Export" from the menu

to export your Access report as a Snapshot File.

2. In Powerpoint, insert a Snapshot Viewer ActiveX Control into the
slide from the Control Toolbox by clicking the "More Controls"
button
and selecting it from the list.

3. After the control has been inserted, right-click on the control
and
select "Snapshot Viewer Control Object Properties".

4. Click the "Browse" button to locate the report you saved in SNP
format. Beware: An absolute path is stored rather than a relative
path. If you move the presentation or the report, the link will be
broken unless you update it in code.

5. Save your presentation and view it.

That's all there is to it.

[jtrisme]

I used ellenh's instructions:

1. In Access, open your report. Choose "File Export " from the menuto export your Access report as a Snapshot File.

2. In PowerPoint, insert a Snapshot Viewer ActiveX Control into theslide from the Control Toolbox by clicking the "More Controls" button and selecting it from the list.

3. After the control has been inserted, right-click on the control andselect "Snapshot Viewer Control Object Properties".

4. Click the "Browse" button to locate the report you saved in SNP format.
Beware: An absolute path is stored rather than a relative path. If you move the presentation or the report, the link will be broken unless youupdate it in code.

5. Save your presentation and view it.

Comment about creating the Snapshot file: For a report in portrait layout, I used a top margin of .5 inches and a bottom margin of 5.5inches. Otherwise, the Snapshot file page length is too long to fit onthe landscape format of a PowerPoint slide.

For subsequent pages in the same Snapshot file, duplicate the existing Powerpoint slide that now shows the first Snapshot file page.

Right click on the Snapshot Viewer object and select Properties.Change the value in the Current Page property from 1 to 2.

Repeat as needed for subsequent pages.

That's it! Simple!

But when I presented it to the users -- At first, they would not mind
to do it manually if the Snapshot contains less than 10 pages -- But
the true fact was that, our exported Snapshot file would rarely have
less than 10 pages (each page is ONE PowerPoint Slide) -- It will take
a lot of time to do it manually if the Snapshot file may contain from
50-200 pages of reports -- Therefore, I have to find a solution in VBA
Code that would be able to break each SnapShot page into PowerPoint
Slides automatically.

Additionally, my users wanted me to create a command button on the data
entry form that after entering the data of a new record -- They would
click on that command button and the data would automatic add into the
existed PowerPoint slides file... and so on --

Any suggestions or VBA codes would be truly appreciated very much.