Microsoft KB Archive/94972

= Hidden Records Displayed After Opening Saved File in Works =

Article ID: 94972

Article Last Modified on 11/24/2003

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 2.0a
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Windows 3.0 Standard Edition
 * Microsoft Windows 3.1 Standard Edition

-



This article was previously published under Q94972



SUMMARY
If you save a Microsoft Works for Windows database file with hidden records, when the file is reopened the records will NOT still be hidden. Works for Windows database files always open with all records showing.



WORKAROUND
There are two methods to work around this:

Method 1: Using a Query

 * 1) Create a query that will hide the desired records.
 * 2) Save the database file. The last query created (step 1) will save with the database.
 * 3) Each time the file is reopened, choose Apply Query from the Select menu to rehide the records.

Note: If you perform any other query(s) on the database after saving it, you will need to enter the original query again and resave the file.

Creating a query is covered in &quot;Querying a database for related records&quot; in the &quot;Microsoft Works for Windows User's Guide&quot; on pages 274-284.

Method 2: Using a Separate File
The database with the hidden records removed could be kept in a separate database file, with the database in its entirety left under its original name.


 * 1) Open the original database file in Works for Windows.
 * 2) Save the file under a different name.
 * 3) Open the new file and delete the records you want hidden.
 * 4) Resave the file using the new name.

To remove the hidden attribute of a record and make it visible in the new database, open the original database and copy the record, then paste it in the new database.

To hide additional records in the new database, delete the records. Deleting records is covered in &quot;Adding and deleting records in a database&quot; in the &quot;Microsoft Works for Windows User's Guide&quot; version 3.0, pages 306-307 or &quot;Microsoft Works for Windows User's Guide&quot; version 2.x: on pages 251-252.

Additional query words: 2.0A loose lost record unhide re-hide un-hide

Keywords: KB94972

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.