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
Calculation Overview
Using Calculations - 225
The Auto Calculation dialog box appears if OmniForm
proposes an auto calculation.
3 Accept or cancel OmniForm’s proposed calculation.
• Click
OK
to accept the calculation.
The calculation appears in the toolbar’s text box.
•Click
Cancel
close the dialog box without creating a calculation.
4 Edit the calculation in the toolbar if you need to:
• Click in the calculation text box and make manual changes, or
click the Calculation Builder button to open the Calculation
Builder dialog box. See “The Calculation Builder” on page
9-222.
• Click the Accept Calculation button to accept changes.
• Click the Cancel Calculation button to close the Calculation
Builder and revert to the version created by OmniForm.
You can manually delete entries in the text box and click the
Accept Calculation button to clear the box entirely. This is
useful if clicking the Cancel Calculation button causes the
calculation to revert to a previously accepted version.
5 Choose
Calculation
in the Tools menu to close the toolbar.
Using the
Recalculate...
Command
Recalculating records applies any new or changed calculations to
all
selected records in a database. Until you use the
Recalculate...
command,
new or changed calculations apply only to new records or to current
records whose relevant field entries change.
See “Recalculating Records” on page 8-14 for detailed information.