Export pivot chart from Data access page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to export a pivot chart from a data access page? I can do it
from a form without a problem, but I believe I need to do it with Javascript
if using a data access page. Any suggestions? I'm using Access 2003.
 
Here's an update of what I've done to get around this; I've stopped using
data access pages, as they don't have the same features that forms do for
command buttons etc, without knowing a lot of visual basic.
I created a pivot chart form and then added this as a subform to a new form.
The new form also has a command button so on click property it will run:
Private Sub Command1_Click()
Dim frm As Access.Form
Set frm = Me.frmPivotChart.Form
frm.ChartSpace.ExportPicture "C:\PivotChart1.jpg", "JPEG"
End Sub
(This exports the chart to C:\PivotChart1.jpg)

For any pivot charts that are in a report, I have a form that generate the
report, then runs a macro to 'output to" and choose the report, name and
format as Snapshot Format. This seems to be the only way to have a static
view of a pivot chart. Note that you must download microsoft snapshot viewer
to see it.
Once the pivot charts are all jpegs/snapshots I can import them to a webpage.
This can be automated I believe to update every day, but I still have to
figure it out. Anyone who wishes to improve this process is very welcome.
Thanks,
Mike
 
Back
Top