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 - 202
6 Select an option under
Scope of Search.
•Select
Search All Records in the Database
to search the entire
record set.
•Select
Only Search Current Record Set
to search a subset of
records. This option is only available when you have a found
set open from a previous search.
7 Click
OK.
OmniForm searches for and retrieves all records that contain
the information you specified in the Search dialog box.
Under the standard toolbar, OmniForm displays the search
information and number of records in the found set. If you
need to narrow the search further, choose
Search...
again.
You might, for example, want to search the Franich & Halsey
record set for invoices from a specific month. You can search
each new subset of records as many times as you need to find
the specific information you want.
OmniForm maintains the current found set if it retrieves no
records during a search.
8 Click
Clear Search
under the standard toolbar to return to the
full record set when you are done.
Search information: the
found set contains five
records.
Click
Clear Search
to return
to the full record set.