Access quits unexpectedly when you programmatically export a Graph object (824276)

RESOLUTION

• Set the Action Property to acOLEClose After the Object Is Exported

  Because the Graph object is contained in an OLE object frame, you can set the Action property of the object frame to acOLEClose. This closes the OLE server and therefore prevents the error. Although this prevents the shutdown, the Graph object is not accessible until you close the form and then you reopen the form.
  
  For example, to resolve the problem that is mentioned in the "Steps to Reproduce the Behavior" section, you must set the Action property of the object frame to acOLEClose. To do this, follow these steps:
  1. Start Access.
  2. Open the database where you want to export the Graph object from.
  3. Open the form that contains the Graph object in Design view.
  4. Insert code that is similar to the following code for the Click event of the command button:

     Private Sub Command1_Click()
         Dim grpApp As Graph.Chart
         Set grpApp = Me.Graph1.Object
         grpApp.Export "C:\Graph1.jpg", "JPEG"
         Set grpApp = Nothing
         Me.Graph1.Action = acOLEClose
     End Sub 
     

  5. On the File menu, click Close and Return to Microsoft Office Access.
  6. On the File menu, click Save.
  7. On the View menu, click Form View.
     
     Notice that the form opens and that the Graph object appears.
  8. Click the command button to export the Graph object to the file that is named C:\Graph1.jpg.
  9. On the View menu, click Design View.
     
     Notice that the form opens in Design view without any errors and that the Graph object is successfully exported to JPEG format.

• Create a PivotChart Object Instead of Using Graph

  When you use the PivotChart view for forms in Access, you can programmatically export the chart to a graphics file to avoid this problem. To create a PivotChart and to programmatically export the chart to a graphics file, follow these steps:
  1. Start Access.
  2. Open the Northwind.mdb sample database.
  3. On the Insert menu, click Form.
  4. In the New Form dialog box, click AutoForm: PivotChart.
  5. In the Choose the table or query where the object's data comes from list, click Sales by Category, and then click OK.
  6. Move CategoryName from Chart Field List to Drop Category Fields Here.
  7. Move ProductSales from Chart Field List to Drop Data Fields Here.
     
     Notice that the chart that appears shows the Sum of Product Sales by Category.
  8. On the File menu, click Close. When you are prompted to save the form, click Yes. Save the form as frmPivotChart.
  9. On the Insert menu, click Form.
  10. Click Design View, and then click OK.
      
      Do not select a table or a query.
  11. Move frmPivotChart from the Database window to the new form.
      
      This creates a subform.
  12. On the View menu, click Properties.
  13. Click the subform object.
  14. In the property sheet, click the Other tab, and then set the Name property to frmPivotChart.
  15. Add a command button to the main form, and then set the Name property of the command button to Command1.
  16. In the Command Button Wizard dialog box, click Cancel.
  17. On the View menu, click Code to view the module of the form.
  18. Use the copy and paste feature to move the following code to the Visual Basic Editor:

      Private Sub Command1_Click()
          Dim frm As Access.Form
      
          Set frm = Me.frmPivotChart.Form
          frm.ChartSpace.ExportPicture "C:\PivotChart1.jpg", "JPEG"
      End Sub
      	

  19. On the File menu, click Close and Return to Microsoft Office Access.
  20. On the File menu, click Save, and then save the form as frmMain.
  21. On the View menu, click Form View.
      
      Notice that the subform appears in PivotChart view.
  22. Click the command button to export the PivotChart to the file that is named C:\PivotChart1.jpg.
  23. On the View menu, click Design View.
      
      Notice that the form opens in Design view without any errors.