B
backToAccess
I used Q287022 to resolve the issue - Access shuts down unexpectedly after
programmatically exporting Microsoft Graph object
Problem: It resolved the original issue of access shutting down, however,
my graph becomes completely corrupted when the form is closed and reopened.
When the form is closed there are no changes saved and the only action
performed is clicking the button to export the graph as an image.
I am using MS access 2002
My code as follows:
Private Sub cmdGif_click()
Dim grpApp As Graph.Chart
Set grpApp = Me.Graph1.Object
grpApp.Export "C:\Graph1.gif", "Gif"
Me.Graph1.Locked = False
Me.Graph1.Enabled = True
Set grpApp = Nothing
Me.Graph1.Action = acOLEClose
msgbox "Image Created"
end sub
After the export gif button is clicked, you can see the graph looking the
way it should. Then the form is closed using a command button with a simple
docmd.close (i even added a acSaveNo)
When the form is re-opened, the graph has changed the axis values, the
labelling, and even the type.
Help???
CY
programmatically exporting Microsoft Graph object
Problem: It resolved the original issue of access shutting down, however,
my graph becomes completely corrupted when the form is closed and reopened.
When the form is closed there are no changes saved and the only action
performed is clicking the button to export the graph as an image.
I am using MS access 2002
My code as follows:
Private Sub cmdGif_click()
Dim grpApp As Graph.Chart
Set grpApp = Me.Graph1.Object
grpApp.Export "C:\Graph1.gif", "Gif"
Me.Graph1.Locked = False
Me.Graph1.Enabled = True
Set grpApp = Nothing
Me.Graph1.Action = acOLEClose
msgbox "Image Created"
end sub
After the export gif button is clicked, you can see the graph looking the
way it should. Then the form is closed using a command button with a simple
docmd.close (i even added a acSaveNo)
When the form is re-opened, the graph has changed the axis values, the
labelling, and even the type.
Help???
CY