Microsoft Knowledge Base

MSQUERY: Choosing OK in SQL Dialog Box Using Keyboard
Last reviewed: September 12, 1996
Article ID: Q124607
The information in this article applies to:
  • Microsoft Query for the Macintosh, version 1.0

The SQL dialog box is available by choosing the SQL button from the Microsoft Query toolbar or by choosing SQL from the View menu. You can use this dialog box to view or edit the SQL statement for a particular query. While you are editing the SQL statement, you can press ENTER to create a new line in the statement. Because of this functionality, you must press COMMAND+O to close the SQL dialog box using the keyboard or choose the OK button.

This behavior is by design. Note also that this behavior is the same as it is in Microsoft Query for Windows.

Note that in Microsoft Query for Windows, you can press ALT+O to close the SQL dialog box as is indicated by an underline character below the O in OK, or you can press TAB until the OK button is selected, and then press ENTER.

Note also that on the Macintosh system, most dialog boxes do not have accelerator keys.

REFERENCES

For more information about how to View Or Edit An Existing Query's SQL SELECT Statement, choose the Search button in Help and type: 

   SQL statements

KBCategory: kbtool
KBSubcategory: xlquery xlmac

Additional reference words: 1.00 5.00



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" 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.

Last reviewed: September 12, 1996
©1997 Microsoft Corporation. All rights reserved. Legal Notices.