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 - 201
•
does not end with:
find records that do not have the
Value
entry
at the end of the selected field or records that do not contain
the value entry at all.
This search finds records that do not have
Franich & Halsey
at
the end of an entry in the
Customer
field.
•
contains:
find records that contain the
Value
entry.
This search finds records that have
Franich & Halsey
entered
anywhere in the
Customer
field.
•
does not contain:
find records that do not contain the
Value
entry.
This search finds records that do not have
Franich & Halsey
entered anywhere in the
Customer
field.
•
is empty:
find records that have no entry in the selected field.
The
Value
text box is disabled if this is selected.
•
is not empty:
find records that have an entry of any sort in the
selected field.
The
Value
text box is disabled if this is selected.
5 Type the text to find in the
Value
text box.
Information is not case-sensitive. Typing Los Gatos is the
same as typing los gatos.
How OmniForm searches for the information in the
Value
text
box depends on the selection in the
Condition
drop-down list as
described in the previous step.