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
Error Messages
Technical Information - 269
Calculation Error: Invalid Field Name. Correct the field name or
enter another in the expression for [field name].
A field name in your calculation does not exist in the form. It may be
misspelled or it may have been deleted from the form after the
calculation was previously accepted. Correct the field name, add it to the
form if it is missing, or change the calculation.
Calculation Error: Invalid Field used in calculation. [field name1]
cannot be used in the Expression for [field name2].
You used an invalid field, such as a fill graphic, in a calculation. Only fill
text, comb, check box, and circle text fields can be used in calculations.
Calculation Error: Missing ']'.
The calculation is missing a bracket. All field names that contain a space
must be enclosed by brackets. OmniForm does not automatically insert
brackets around a manually created field name that contains a space.
You must bracket these manually.
Calculation Error: Missing '('.
The calculation is missing a left parenthesis. (The same message with a
right parenthesis appears if that is missing.) Parentheses must enclose
an entire function.
It is easy to leave out a parenthesis in a long, manually created
calculation containing multiple functions. Try using the Calculation
Builder instead so that OmniForm inserts parentheses automatically.
Printer error. Unable to use macro to print form. Make sure you
have assigned a Macro Number. If this has been assigned, then
the current printer may not support macros.
See “Printing Your Form as a Macro” on page 100 for information on this
feature.
Scrapbook error. Try freeing up hard disk space, and close
open forms and applications to free up memory.
If disk space or memory is not low, this message may appear because the
Scrapbook (OFS) file is missing or corrupted. A scrapbook file moved or
deleted from the OmniForm\Scrapbooks (omniform\scrapbks in
Windows 3.1) folder while OmniForm is open will still appear in the
Scrapbook
drop-down list. If you select it, this message appears.
Restart OmniForm to update the list of scrapbooks if you delete an OFS
file from the hard drive.