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
Menu Commands
OmniForm Procedures - 114
• The Record Number text box displays the number of the record
you are viewing. Highlight the number, type in a new number,
and press Enter to move to that record.
•Select
Next
to move to the record after the one you are viewing. If
record 3 is on view, for example, record 4 is the next record.
•Select
Last
to move to the last record in your database.
•Select
New
to create a new, blank record. You must have a form
open and at least one field filled manually to create a new record.
Search... — Search for information in your database records.
Sort... — Sort database records by a selected field in ascending,
descending, or creation order.
Duplicate Record — Make an exact copy of the current record,
including all information in the record. You must have an open form
with at least one field filled manually to duplicate a record.
Recalculate... — Apply new or changed calculations in your database
to the selected records. Otherwise, new or changed calculations apply
only to new records.
This command reapplies
all
existing calculations to the selected records.
Make sure you know which calculations are in your database before
using this command.
Delete Record — Delete the record being viewed. OmniForm prompts
you to confirm your action. Export information from a record first to
delete the record but save its data.
You cannot undo the
Delete Record
command.
Delete All Records — Delete all records in your database or to delete
a found set of records. OmniForm prompts you to confirm your action.
Export information from records first if you want to delete the records
but save the data.
You cannot undo the
Delete All Records
command.