OFF98: Undo Criteria Removes All Criteria Fields and Tables (193475)
The information in this article applies to:
- Microsoft Office 98 Macintosh Edition
- Microsoft Excel 98 Macintosh Edition
- Microsoft Query
This article was previously published under Q193475 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 COMMAND+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 you do all of the following in Microsoft Query:
- 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 98
Macintosh Edition.
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:
179216 OFF98: How to Use the Microsoft Office Installer Program
| Modification Type: | Major | Last Reviewed: | 11/13/2003 |
|---|
| Keywords: | KB193475 |
|---|
|