Agee Software, Inc.

Programming Standards

Security

Microsoft user level security. Encrypted. Access control by user for each form & report. UserID on main menu.

Navigate w/Keys

Perform all functions using either keystrokes or mouse

Shortcut Keys

Alt-N for New record. All command buttons that don't destroy data have this feature.

Tooltips

Hover over any command button for one second to see yellow box describing its function.

Status Bar Text

Status bar at bottom of screen describes the current text field

Locked Fields

Fields user can update are sunken and white. Locked fields are etched and gray.

Key Navigation

PgDn & PgUp move to next/previous record in single form. Ctrl-PgDn/PgUp moves in continuous form.

Multi-user

If two users change a record, second user is warned that record has changed.

Audit Trail

Each record update is stamped with time and user. Alt-Z to view audit stamp.

Record Count

Record x of y records at bottom of each form.

Export Reports

Each can be exported to CSV, DBF, RTF, TXT & XLS.

Hyperlink Labels

Blue underlined label opens form at record selected for foreign key fields.

Forced Quit

Super user can gracefully force all users to quit the database for maintenance.

Links

Super user can change link to 'back-end' data tables for archive, backup, training or stand-alone operation.

Form Color

Super user can select form color for all forms. Helps user recognize he is logged in as Super or stand-alone.

Quick Date Entry

Plus key adds a day to any date, minus subtracts a date. Double-click clears or sets to today's date.

Object descriptions

Each query, form and report is fully described.

Comments

used in module code. Naming convention used for all object names.

Version Number

Databases with identical version numbers are identical. Users may automatically download update.

Report Menu

Fully describes each report and offers report unique parameters.

Consistent Reports

Each report shows date and time, page number, report name and database name.

Compiled & Compacted

Database always delivered compacted and free of compile errors.

Close