J
Jeff
Stephen,
I appreciate your insight. I accessed your report
utilities, and made some progress. However, I am using
2000 and the following VBA produces a "User-defined type
not defined" error in debug mode.
Dim pf As clsPrintToFit
Any suggestions.
I appreciate your insight. I accessed your report
utilities, and made some progress. However, I am using
2000 and the following VBA produces a "User-defined type
not defined" error in debug mode.
Dim pf As clsPrintToFit
Any suggestions.
..-----Original Message-----
Use the ReportUtilities on my site to export the Report as a series of
EMF files, one for each page of the Report. EMF's can be directly loaded
onto PP slides and are fully scaleable, resolution inependant.
http://www.lebans.com/ReportUtilities.htm
Please note, if you just want the Graph off of each page of the report
then the CHart object has an Export method. Here is a post from SteveT
on this subject. THe example code is for a Form but you can adapt it for
your report
From: SteveT (SteveT)
Subject: Re: export chart
View this article only
Newsgroups: microsoft.public.access.forms
Date: 2002-09-19 15:24:04 PST
Create two command buttons and paste the code below into the click
events.
Paste the ExportRs function in the same module and note the code to go
into
the Form Error event.
Steve
To save image:
Private Sub cmdSaveChart_Click()
'use this to export as a jpg, "gif" also works
Dim ochart As Object
Set ochart = Me.Graph1.Object
oChart.Export "c:\temp\MyChart.jpg", "jpeg"
oChart.Application.Quit
Set ochart = Nothing
End Sub
--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
.