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 - 205
The Recalculate dialog box appears.
3 Select the records to recalculate.
•Select
All Records
to apply the new or changed calculation to
either the current found set or to every record in the database
if the entire record set is open.
•Select
Current Record Only
to apply the new or changed
calculation to just the record you are viewing.
•Select
From/To
to apply the new or changed calculation to a
range of records.
Enter a number in the
From
and
To
text boxes. If you entered 1
in the
From
text box and 5 in the
To
text box, for example,
OmniForm would recalculate the first five records in your
database or found set.
4 Click
OK.
OmniForm recalculates the records according to your
specifications.
5 Click
OK
in the dialog box that informs you how many records
were recalculated successfully.
You cannot undo a recalculation!