OFF97: Undo Criteria Removes All Criteria Fields and Tables

• Microsoft Query 97 for Windows
• Microsoft Office 97 for Windows

SYMPTOMS

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.

CAUSE

This problem occurs when all of the following are true:

• You do not have the Automatic Query set to On.


-and-


• You click Undo on the Edit menu.

WORKAROUND

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.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Query 97 for Windows.

MORE INFORMATION

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.

REFERENCES

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:

Q120802 Office: How to Add/Remove a Single Office Program or Component

Additional query words: XL97

Keywords : kbdta xlquery
Version : WINDOWS:97
Platform : WINDOWS
Issue type :