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 - 199
To simplify searches, give each field a unique name. Otherwise, you
will have fields named
FillText1
,
FillText2,
and so forth, making it
difficult to determine which fields contain what information. See
“Defining Objects” on page 137 for detailed information.
4 Select a condition in the
Condition
drop-down list.
A condition describes how to look for information entered in
the
Value
text box. For example, suppose you entered the words
Franich & Halsey in the
Value
text box.
The following bulleted items show the results of a search using
each available condition option. Proceed to step 5 on page 201
if you already know which condition to select.
•
is equal to:
find an exact match of the
Value
entry.
This finds records that have
Franich & Halsey
and nothing else
in the
Customer
field.
•
is not equal to:
find anything but the
Value
entry.
This finds records that have anything but
Franich & Halsey
in
the
Customer
field.
•
is greater than:
find records of greater value than the
Value
entry.
This finds records that have entries in the
Customer
field later
in the alphabet than the entry, for example,
Franklin
or
Gallatron, Inc
.
•
is greater than or equal to:
find records of equal or greater value
than the
Value
entry.
This search finds records that have entries in the
Customer
field beginning with the entry name itself up to the letter
Z
.