Cannot Disable ToolTips Directly from Microsoft Query

Article translations Article translations
Article ID: 107254 - View products that this article applies to.
This article was previously published under Q107254
This article has been archived. It is offered "as is" and will no longer be updated.
IMPORTANT: This article contains information about editing the registry. Before you edit the registry, you should first make a backup copy of the registry files (System.dat and User.dat). Both are hidden files in the Windows folder.
Expand all | Collapse all

On This Page

SUMMARY

You cannot disable ToolTips from within Microsoft Query. If you do not want ToolTips to be displayed, do the following according to the version of Microsoft Query you are using:

Microsoft Query for Windows 95, version 2.0

WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows 95. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.
For information about how to edit the registry, view the Changing Keys And Values online Help topic in Registry Editor (Regedit.exe). Note that you should make a backup copy of the registry files (System.dat and User.dat) before you edit the registry.

  1. Click the Start button, and then click Run.
  2. In the Open box, type "regedit", without quotes.
  3. Locate the HKEY_CURRENT_USER registry folder.
  4. Expand the HKEY_CURRENT_USER folder until you locate the "SOFTWARE\Microsoft\Query\2.0\Microsoft Query" folder.
  5. Click the Microsoft Query folder.
  6. On the Edit Menu in the Registry Editor, click New, and then click Dword Value.
  7. Type "Tooltips" (without the quotation marks), and then press ENTER.
  8. Click Exit on the Registry menu to exit the Registry Editor.
Using the steps above, the new Tooltips key will be set to 0. When this key is 0, the tooltips will not display in Microsoft Query 2.0. To display the tooltips in Microsoft Query again, either set the Tooltips key to 1 or delete the Tooltips key.

Microsoft Query, version 1.0

Change the MSQUERY.INI file:

  1. If you are in Microsoft Query, quit the application.
  2. Use a text editor, such as Windows Notepad, to open the MSQUERY.INI file (this file should be located in the WINDOWS directory).
  3. In the [Microsoft Query] section of MSQUERY.INI, add the following line:

    ToolTips=0
  4. Save the MSQUERY.INI file and quit the text editor.
When you restart Microsoft Query, ToolTips will no longer appear.

To re-enable ToolTips, remove the "ToolTips=0" line from the MSQUERY.INI file.

Properties

Article ID: 107254 - Last Review: October 21, 2013 - Revision: 1.4
APPLIES TO
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 5.0 Standard Edition
  • Microsoft Query 2000
Keywords: 
kbnosurvey kbarchive KB107254

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com