Hidden Records Displayed After Opening Saved File in Works (94972)



The information in this article applies to:

  • Microsoft Works 2.0
  • Microsoft Works 2.0a
  • Microsoft Works 3.0
  • Microsoft Windows 3.0
  • Microsoft Windows 3.1

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 "Querying a database for related records" in the "Microsoft Works for Windows User's Guide" 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 "Adding and deleting records in a database" in the "Microsoft Works for Windows User's Guide" version 3.0, pages 306-307 or "Microsoft Works for Windows User's Guide" version 2.x: on pages 251-252.

Modification Type:MajorLast Reviewed:11/24/2003
Keywords:KB94972