2.0
Table Of Contents
- Introduction
- Installation and Setup
- Tutorials
- Views and Form Usage
- OmniForm Procedures
- Designing a Form
- The Design Process
- The Design View Toolbars
- Creating Objects
- General Creation Guidelines
- Creating a Text Object
- Creating a Line Object
- Creating an Oval Object
- Creating a Rectangle Object
- Creating a Graphic Object
- Creating a Fill Text Object
- Creating a Comb Object
- Creating a Check Box Object
- Creating a Circle Text Object
- Creating a Table Object
- Creating a Fill Graphic Object
- Defining Objects
- Changing Object Appearance
- Redesigning Your Form
- Using the Scrapbook
- Inserting OLE Objects in a Form
- Filling a Form
- Managing an OmniForm Database
- Using Calculations
- Calculation Overview
- Operators
- Functions
- Abs (Absolute Value)
- Avg (Average)
- Date (Current Date)
- DayName
- DayOfMonth
- DayOfWeek
- DayOfYear
- Exp (Exponentiation)
- FV (Future Value)
- Hour
- If
- Int (Integer)
- Left
- Length
- Ln (Natural Logarithm)
- Log (Base 10 Logarithm)
- Lower
- Max (Maximum)
- Middle
- Min (Minimum)
- Minute
- Mod (Modulus (Remainder))
- Month
- MonthName
- Pi
- PMT (Payment)
- Position
- Proper
- PV (Present Value)
- RecordCount
- Replace
- Replicate
- Right
- Round
- Second
- Sign
- Sqrt (Square Root)
- Sum
- Time
- Trim
- Trunc (Truncate)
- Upper
- Year
- Functions — Quick Reference
- Functions Sorted by Type
- Technical Information
- Glossary
Managing Database Records
Managing an OmniForm Database - 206
Deleting Records
This section describes how to delete one or more records in a database.
Do this to get rid of old, unwanted, or duplicate records.
You can export information from a record first if you want to delete a
record but save its data. See “Exporting Information” on page 207 for
instructions.
You cannot delete a record if data protection is turned on. See
“Protecting Your Database” on page 217 for information.
To delete the current record:
1 If you are in design view, click the Fill button in the standard
toolbar or choose
Fill
in the View menu to switch to fill view.
2 Choose
Delete Record
in the Records menu.
A warning dialog box appears.
3 Click
Yes
to delete the current record permanently.
You cannot undo a record deletion!
To delete all records:
1 If you are in design view, click the Fill button in the standard
toolbar or choose
Fill
in the View menu to switch to fill view.
2 To delete a found set of records instead of all records, click
Search...
in the Records menu to find the records to delete.
See “Searching Records for Information” on page 198 for more
information.
3 Choose
Delete All Records
in the Records menu.
A warning dialog box appears.
4 Click
Yes
to delete all records or the found set permanently.
You cannot undo a record deletion!