How to export complex reports into PowerPoint
On the Control ToolBox is the Icon for "more Tools...". This will bring
up all of the installed ActiveX control on your system. If the
Miscrosoft SnapShot viewer has been installed then you will see a
listing for
SnapShot Viewer Control 8.0 or 9.0
Select this and then Draw the Control on your Page to the desired size.
Do not double click but Right CLick over the control. From the Popup
menu select "SnapShot View Control" and then the proeprties for this
control. Here you can set the SNapSHot filename you want to point to
etc. All of these props can be set via code.
Good Luck.
--
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Quote:
> Stephen,
> I created the report.snp snapshot file OK, but I seldom use PowerPoint
and
> the reports have to be exported to PowerPoint for the customer.
> Consequently I am not sure what to do next.
> I tried two methods so far;
> First I opened the Control Box and clicked on Snapshot Control Viewer
9.0,
> drew a box on the powerpoint slide and it turned black. I clicked on
it and
> was thrown into code:
> Private Sub SnapshotViewer1_FirstPage()
> End Sub
> I do a lot of programming in Access 97 but don't know what to do here
to
> show a page of the report.
> The other thing I tried was
> Insert | Object | create from file | c:\report.snp
> That gave me the first page of my 35 page report. The entire page
shows up
> on the slide but in the background is a black box with a shadow about
1/4
> the size of the page which I can't get rid of.
> I think the first option, somehow selecting page numbers for each page
is
> what I want but would appreciate more help in doing this.
> Thanks for your help so far.
> Michele
> > Michele you can use SnapShot format, so export the Report to
SnapShot
> > format as you would normally . Next insert the SnapShot ActiveX
control
> > onto the PowerPoint page. Get into the properties of this control
and
> > set the FileName and Current Page number. This could all be done
> > programmatically via VBA.
> > The Control can obviously only display one page at a time. I have
never
> > programmed the object model of PowerPoint but I would imagine there
has
> > to be an event as each page is presented. SO you could either embedd
a
> > seperate instance of the SnapShot ActiveX control on each page of
your
> > presentation or keep your Presentation pages seperate from the
Report
> > Page and via code select a different current page as each page of
the
> > presentation is viewed.
> > Sorry about the poor explanation...stag party for my new brother in
law
> > last night. :(
> > --
> > Stephen Lebans
> > http://www.lebans.com
> > Access Code, Tips and Tricks
> > > I have reports which include multiple charts, .bmps, lines and
> > sub-forms
> > > which the users want to be able to view in PowerPoint and use as
> > slides in
> > > weekly presentations. I tried to "Publish it with Word" but all
my
> > lines,
> > > pictures and graphs disappeared. Doing this through code seems
> > impossible,
> > > using the Snapshot viewer doesn't get it into PowerPoint. I need
to
> > make it
> > > as simple as possible; ie: push a button and tell what to save as
and
> > it's
> > > done!
> > > TIA,
> > > Michele
