ID: Q193480
The information in this article applies to:
When you add criteria to the criteria pane in Microsoft Query and undo your last action by clicking Undo on the Edit menu (or Ctrl+Z), all of the fields in the criteria pane are removed and all of the tables are removed from your query.
This problem occurs when all of the following are true:
-and-
To work around this problem, set the Automatic Query feature to On before you attempt to undo any actions in the criteria pane. To turn on the Automatic Query feature, click the Auto Query button or on the Records menu, click Automatic Query. Note that when this feature is enabled, the Auto Query button will appear pressed and the Automatic Query command on the Records menu will appear with a check mark.
Microsoft has confirmed this to be a problem in Microsoft Query 97 for Windows.
In Microsoft Query, there are several ways you can retrieve external data. When you want to create a simple query or criteria for creating a more complex query, you can use the Query Wizard. A criteria is a method of filtering the data by specifying values to match records within certain fields. Microsoft Query allows you to view the result set in its data pane. When you are sure the result set contains the data you want, you can return it to Microsoft Excel.
For more information about adding criteria, click the Office Assistant, type "criteria," click Search, and then click to view "Specify what records to retrieve by using criteria."
NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If Microsoft Help is not installed on your computer, please see the following article in the Microsoft Knowledge Base:
ARTICLE-ID: Q120802
TITLE : Office: How to Add/Remove a Single Office
Program or Component
Keywords : kbdta xlquery
Version : WINDOWS:97
Platform : WINDOWSLast Reviewed: May 25, 1999