Microsoft KB Archive/93722

{|
 * width="100%"|

PRB: Microsoft Access Cannot Paste Entire Column in Query Grid
'Article ID: Q93722

Creation Date: 20-DEC-1992

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


 * Microsoft Access versions 1.0, 1.1, 2.0

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

When you use the Query By Example (QBE) grid, an attempt to cut and paste (or to copy and paste) an entire column into a cell places incorrect results into the target cell.

RESOLUTION

Before you paste information from the Clipboard, select an object that has the same size as the information in the Clipboard. In this example, select an entire column when you paste the information into the query grid.

STATUS

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

MORE INFORMATION

Steps to Reproduce Behavior


 * 1) Create a query.
 * 2) Select an entire column in the query grid (click the mouse once at the top of a column when the mouse pointer changes to a down arrow).
 * 3) From the Edit menu, choose either Cut or Copy.
 * 4) Select a cell (to paste the copied column into) and choose Paste from the Edit menu.

The initial value displayed will probably be a 1, which indicates that the Show box was selected in the column you copied. Hold the SHIFT key down and press the F2 key to bring up the Zoom Box. In the Zoom box you'll notice that you've pasted the entire column into the cell, Field Name - Table or Query - and 1 or 0 for Show. If you attempt to move off the cell by clicking elsewhere on the grid, you will receive a syntax error message. After closing the Zoom Box press ESC to remove the paste. REFERENCES

For more information about pasting information in the query grid, please see the following article here in the Microsoft Knowledge Base:

ARTICLE-ID: Q96457 TITLE:     PRA: Cannot Paste Column If Focus Is on One Cell in Query
 * }

-

"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

KBCategory: kbui

KBSubcategory: UifOthr