Iowa State University Extension

Blue Ribbon Support

Youth and Parents Volunteers and Leaders Teachers Staff Members Home

Blue Ribbon Help Sheets

Virtual Blue Ribbon Party weblog

File Maintenance | Common Error Messages | Queries | Forms and Reports
Working with Records | Statistical Reports | Other | Installation

File Maintenance

BDE Admin settings for the X Drive	Setup Fair computers (WinFair pgm. @ fairgrounds, no network)
Using Datafix
Packing Tables	Make a Copy of the Data folder
List of files in the Data folder	Remove Duplicate Projects

Common Error Messages

Key Violation	Invalid File Name; Unable to Access the Network Drive
Error Creating Cursor Handle	File is controlled by another user
Index is Out of Date	On a report, the phone numbers "disappeared"
Member ID is not indexed

Queries

Changing Export Level	Exporting from Member Query to Excel
Using Filters in Queries	Exporting from Member Query to new Filemaker database
SQL queries to change data	Exporting from Member Query to existing Filemaker database

Forms and Reports

Program Fee Report	Video of Program Fee
Extension Finance Remittance form for Special Programs
Ordering Pubs on the Web	Saving Reports as RTF (Word)
ID Labels	Saving Reports as Excel
Printing Enrollment Forms	Adding Photo Permission to Enrollment Forms
Stat Reports ("how many")	Printing lists of members with fee/photo/behavior checkboxes
Mailing Label Options	Creating custom mailing labels (new postal regs. for bulk mail)

Working with Records

Recording Independent Members	Recording Volunteer Leader Training
Setting Preferences	Changing a Member's ID
Adding a new member, parents	Deleting Members & Parents
Adding Club Memberships	Deleting a Club
Adding Member Projects	Tracking Program Fees

ES-237 Reports, Year-end

New User Stats manual (2008)	Successful Statistical Reports (includes Year-end info, updated 2008)
Recording Volunteer Leader Training	Entering Group Enrollments
Recording Independent Members	Entering Volunteer Enrollments
Statistical Definitions	Entering Training Log
Category & Status Definitions	Make a Copy of the Data folder (*AFTER stats, BEFORE year-end)
Grade & Residence Definitions	Year-End Processing (*AFTER stats are done & sent in)

Other, Miscellaneous

Using the Help Screens	Changing Export Level (do this before any exports)
Create an Email List (Queries)	Creating a text file
	Word mail merge w/ASCII file

Installation

Updated for X drive	Install Blue Ribbon on a new computer
	County Access Codes (if you've misplaced your sheet)

Blue Ribbon Support Contact: Becky Nibe, 800-689-6589