The Search & Hide/Delete function is used to locate records matching Search criteria and either Hide, UnHide, or Delete the records.
To use Search & Hide/Delete
- Select the appropriate database.
- Select Search & Hide/Delete from the Find.
- Choose either Hide Records, UnHide Records, or Delete Records to display the Search screen. The Search screen looks like a Database record, but all of the fields are blank and the word "Search" is displayed in the lower right corner of the screen.
- Enter the Search criteria in the appropriate fields. Search Operators may be used with the search criteria. Search criteria may be entered in as many fields as necessary. Select the Lookup List button (or press [Ins] or [F2]) to display a list of the currently available options for a field (if options are available for that field).
Press [F10] or [PageDown] to begin the search.
- When the Search locates the first record that matches all of the Search criteria, a prompt is displayed asking to Confirm change to each record. Yes is the recommended answer. The first record matching the Search criteria is displayed and the "Update this record (Yes/No/All)" prompt is displayed at lower left corner of the screen.
For Search & Hide Records and Search & Unhide Records:
- Select Yes to Hide or Unhide the record and continue to the next record that satisfies the Search criteria.
- Select No to not Hide or Unhide the record and continue to the next record that satisfies the Search criteria.
- Select All to Hide or Unhide the record and continue Hiding or Unhiding all the records that satisfy the Search criteria without prompting for confirmation.
For Search & Delete:
***Always make a Backup copy of the database files before using the Search & Delete function.***
- Select Yes to Delete the record and continue to the next record that satisfies the Search criteria.
- Select No to not Delete the record and continue to the next record that satisfies the Search criteria.
- Select All to Delete the record and continue Deleting all the records that satisfy the Search criteria without prompting for confirmation.
Note: The Search & Delete function can wipe out much or even all database record information.
***Always make a Backup copy of the database files before using the Search & Delete function.***
See:
Special Search Operator Characters
Search & Hide/Delete Replacement Formulas
Database Manager Contents