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 - 200
•
is less than:
find records of lesser value than the
Value
entry.
This finds records that have entries
in the
Customer
field
beginning with a symbol, a number, or letters earlier in the
alphabet than the entry, for example,
France
or
Dharma Dogs
.
•
is less than or equal to:
find records of equal or lesser value than
the
Value
entry.
This finds records that have entries
in the
Customer
field
beginning with a symbol, a number, or the letter
A
up to the
entry name itself.
•
begins with:
find records that begin with the
Value
entry.
This search finds records that have
Franich & Halsey
as the
entry or at the beginning of an entry in the
Customer
field
.
•
does not begin with:
find records that do not begin with the
Value
entry or that do not contain the value entry at all.
This search finds records that do not have
Franich & Halsey
as
the beginning of the entry in the
Customer
field or records that
do not contain
Franich & Halsey
at all.
•
ends with:
find records that have the
Value
entry at the end of
the selected field.
This search finds records that have
Franich & Halsey
as the
entry or at the end of an entry in the
Customer
field.