Microsoft KB Archive/90101

{|
 * width="100%"|

PRB: When Column Selected and Deleted, Query Grid Disappears
'Article ID: Q90101

Creation Date: 08-OCT-1992

Revision Date: 19-SEP-1996' The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1, 2.0

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

The Query by Example (QBE) grid, which appears when you open a Microsoft Access query in Design view, disappears when you do the following:


 * 1) Select the grid by highlighting the column header.
 * 2) Extend your selection to the end of the query grid.
 * 3) From the Edit menu, choose Delete.

CAUSE

When you select an entire column on the query grid and choose Delete from the Edit menu, Microsoft Access deletes the columns, rather than deleting the data within the columns.

RESOLUTION

To display a blank column after the query grid has disappeared, choose Insert Column from the Edit menu.

To display a column in which the fields already contain data, either select a field from one of the lists displayed and drag it to the query grid, or double-click the field.

STATUS

This behavior no longer occurs in Microsoft Access for Windows 95 version 7.0.

REFERENCES

Microsoft Access &quot;User's Guide,&quot; version 1.0, pages 92-100
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED &quot;AS IS&quot; WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''

Additional reference words: 1.00 1.10 2.00 blank

KBCategory: kbui

KBSubcategory: UifOthr