• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

Reversing the X-Axis and Legend Labels

Q1: After changing the Row Source property of a chart to the qry1997MonthlySalesByCategory query, the product categories appear in the chart as the x-axis labels, and the month abbreviations appear in the legend.
In the example of the "Creating a Graph from a Crosstab Query" section, you didn't change to Series in Rows in step 13. Crosstab queries you design can have the legend values (representing a series of lines) as column headers or row headers. If your x-axis and legend labels are wrong, activate the chart, choose Data, and then choose either Series in Columns or Series in Rows to make the change.

Fixing Errors When Opening OLE Objects

Q1: An "Insufficient memory" or "Application not properly registered" message appears after double-clicking a data cell in the OLE Object field.
Either of the two messages can occur under low-memory conditions. First, try closing all other running applications and then double-clicking the data cell again. "Insufficient memory" errors commonly result from insufficient free disk space on the drive used for the Windows swap or paging file. If you continue to receive registration error messages, exit and restart Windows. If this procedure doesn't solve the problem, open the Registry Editor (RegEdit); choose Edit, Find; and search for the Bitmap Image value. Expand the CLSID entry for Bitmap Image and select the LocalServer32 item. Verify that the value for LocalServer32 is C:\PROGRA~1\ACCESS~1\MSPAINT.EXE—or the location of Mspaint.exe on your PC. (The LocalServer32 entry contains the DOS name of the folder in which Paint is installed: C:\Program Files\Accessories, by default.) If you need to change the entry, double-click the "ab" icon in the right pane to open the Edit String dialog and correct the entry as necessary.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint