Hello folks,
  Last year someone posted some code for exporting a access report directly to
powerpoint.  Does anyone have that?

  Les

I have not seen code to perform the export directly via Automation. I do
have a solution whereby one of the methods of exporting Reports is to
individual Metafile images for each page of the Report. You can directly
import these Metafiles into Powerpoint.
 http://www.lebans.com/ReportUtilities.htm

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

Hello folks,
  Last year someone posted some code for exporting a access report
directly to
powerpoint.  Does anyone have that?

  Les

This is not code, but may fit the bill for you:

Sending reports from Access 97 to Powerpoint

Note: Office 97 must have the SR-1 Patch installed.

The Snapshot viewer may also be needed, but it might be in the above patch.
Download if necessary from Microsoft:
http://support.microsoft.com/support/kb/articles/Q172/3/48.asp and
http://support.microsoft.com/support/kb/articles/Q175/2/74.ASP

Go into the Access 97 database and run the report.
Select: File | Save As/Export | To an External Database | Snapshot format
and give the report a name, e.g.: RiskAbatement_rpt.snp

Open PowerPoint, a blank slide.
If the Control Toolbox is not visible, go to
View | Toolbars | Control Toolbox
Select the bottom button which says More Controls
Choose Snapshot Viewer Control 9.0, draw a large box on the slide; it will
turn black.
Right click on the new box you drew, choose properties
For SnapshotPath use the path and name of the Snapshot file created in
Access, e.g.: c:\access\RiskAbatement_rpt.snp
Change Zoom (it's a selection box) to    5 - snapZoom75percent
Close the properties box.
Shrink the black border as much as possible, the left and top will not go
away completely, so leave an equal amount of black on all sides.
Save the PowerPoint presentation.
Now run the slide show.  There is one page with a page number selector at
the bottom, same as in Access; you scroll between the pages and it doesn't
seem to lose resolution!

Note:
When moving the PowerPoint presentation to another location the snapshot
file must go with it, and the reference in the slide must remain correct;
e.g.: c:\access\RiskAbatement_rpt.snp or be changed to the new location;
e.g. c:\My Documents in your PowerPoint slide SnapshotPath.

HTH
Mich

Hello folks,
  Last year someone posted some code for exporting a access report directly
to
powerpoint.  Does anyone have that?

  Les