Access won't export graphics as you'd expect.
If it's the chart you want, build it on a form and use this code to export
the chart/graph to a JPEG or GIF:
Private Sub cmdExport_Click()
Dim strFile As String
strFile = InputBox("Please Enter a valid path and file name (ie:
c:\temp\graph.jpg)", "Save As?", "c:\temp\graph.jpg")
Dim gObj As Object
'the graph in this example is named "Graph1"
Set gObj = Me.Graph1.Object
gObj.Export strFile, "JPEG" ' "GIF" also available
Set gObj = Nothing
Me.Graph1.Action = acOLEClose
End Sub
Steve
