New features:
1. Added explanation of email test status codes. Accessible by double-click.
BUG fixes:
1. Fixed errors in OD-1 printed report.

BUG fixes:
1. Fixed handling of email status codes. Email addresses with code > 3 are ignored.

New features:
1. Added the ability to plug text into User Defined Fields as one of the data stuffer options.
   Added an option to add stuffer data to tagged fields only. 
   This allows different text strings to be applied to groups of selected records in the target user field.
2. Added check of email status code to emailing functions. Bad emails will not be used.
BUG fixes:
1. Modified Rank decoding to support leading 9 used by HQ to prevent overriding P/C/C with lesser rank. 

New features:
1. Added to "Settings" menu a means to disable MM spell check utility.
2. HQ Email test result displays status number. 
   DB2000 blocks use of address for any value other than zero or null.
   The local status is cleared if Email address is changed. 
   The new address is included in the BDU upload.
3. Added a new page layout to D&D print utility. 
   Squadron OD-2 form information in a district database. 
4. In organization grid, expanded the job clearing and saving 
   capabilty to provide better options.
BUG fixes:
1. Spelling errors in two committee names.
2. D&D print utility: When getting a saved page layout for organization, 
   committee member indent control did not show.
3. Current commander does not show in retroactive MM commander list. 
   Needs to be there in case of serving in a prior year.
4. Database table relations had become corrupt causing some DB queries 
   to fail. Added a procedure to rebuild.
5. Importing jobs fron HQ may have failed for some, due to a faulty flag reset. 
   Result was that occasionally a record was skipped.

New features:
Refined file order listing when opening a backup database
BUG fixes:
1. When updating the database, clearing the N level jobs listed in the 
   HQref database "Rosetta" table from the DB2000 database table 
   "MemberCom" also erased selective S and D level non-OD jobs causing data loss.
2. Contextual help was disabled on some program forms.
3. In H701 and H702 Archived historian database files were not listing when 
   "Open Archive" was used.

New features:
Made DB2000 and historian forms context help sensitive.
1. Added more detail to file description when selecting databases.
2. Added OD form print to "Reports" menu.
3. Name lists can now be positioned using more that first three letters of last name.
BUG fixes:
1. MMSI record sort fixed.
2. If user was an updater for a district database and a duplicate squadron 
    job msg was shown, DB2000 offered to allow an update after correct office 
    holder was selected. District database updaters cannot update squadron job records.
3. If the only database available was not password protected DB2000 wouldn't open it 
    and was getting caught in a loop. It now starts a new database.

Bug fixes:
1. Parse file path to escape &, +, and % in file paths used in http for MM, OD, and Historian.
2. OD-1, 2 form and job related:
a.) Make the DB2000 local database reflect the jobs on file at HQ and remove those that don’t.
Before update all jobs listed in HQref.mdb/Rosetta table are deleted from DB2000 MemberCom table.
If duplicate jobs are on file at HQ and downloaded, they are flagged and the user prompted to decide.
After update, user is prompted to upload a delete action on the duplicates not chosen.
Either way the ODupdate table is flushed.
b.) Prompt for an upload immediately after changing OD form current office holder content. 
ODupdate table content is still held pending if declined.
c.) Retain the last OD upload file as a .log file for reference until a new upload is made. 
Added emailing option to help menu
3. Placed an "Updater" check box in "Authorization" form. 
The purpose is to avoid having most users fool with the data uploads. 
The export menu is removed from the screen. 
The effect of checking when not having an updater password is no different from current version.
However, in this case, the first time an update attempt fails rights test, the "Updater" flag is again set false.
4. When importing email roster updates, any existing ",exe" file will be deleted prior to renaming the ".ex_" file.
5. Further changes to correct cell phone data formatting.
6. In merit marks: View, flag and log any member that doesn't have a matching squadron number in HQref.mdb. 
   Added emailing option to help menu
7. Changed Help Desk URL to jrb@usps.org

Bug fixes:
OD-1, 2: Several adjustments
1. Corrected the error in effective year after COW if in current year.
2. Update HQ_OD field in table "MemberCom" after a successful OD form upload 
otherwise change stays active until a new download is made.
3. Empty the table "ODupload" when updating roster otherwise pending upload may clash with 
new download. Unaffected parts of the pending upload table will be refilled automatically when OD form is revisited.
CSV File
Making a list of tagged records from the organization grid did not work correctly.
Format issue with "Cellphone" in CSV file is corrected independent of any action by Robert..
D&D Roster Printer
Revised error handling routine to "resume next" for a 380 error. 

Bug fixes:
1.  Error in initialization of variable in Org grid causing inability to tag all records.
2.  Removed some restrictions on affilates in the OD1/2 form.

Bug fixes:
1.  Error in Rosetta table causing MM to queue to wrong reviewer
2.  Spurious error in OD1/2 forms
    Changes were not always saved
    Upload via web did not always work correctly 
New Features:
1.  Rearranged File and Help Menus
       Grouped database functions under "Database Operations"
       Grouped help subject under "Help Topics"

Bug fixes:
1.  OD-2 form upload data did not save, causing a file not found error.
2.  Other anomalous behavior with OD form.
     An officer named for an office not on file at HQ and saved for upload remained 
     uploading pending when later removed from that office. Because it was never uploaded the action should have been cancelled.
3.  In User Field grid: Anomalous behavior in refresh of L, R F, G name format
New Features:
1.  Automated the selection of dates for MM submissions with following rules:
    a. If the month in the current year is less than 9:
       Current year and previous year are allowed for original, supplementary and resubmission.
       Retroactive submission years are previous year -2, -3, -4 years
    b. If the month in the current year is equal or greater than 9:
       Current year only is allowed for original, supplementary and resubmission.
       Retroactive submission years are previous year -1, -2, -3 years
Note: An additional date, out of the bounds allowed in the operations manual, can be added for retroactive submission.
2.  Using nickname in user fields.
     Using a check box member nicknames may be substituted for first name in name format options. To qualify a nickname must be present and the nickname preferred option true.

BUG FIX: 
1.Fixed bug in update routine that was created in release 9.0.0. 
This caused update to report all records as being updated even when 
there was no difference between the download and the database.

BUG FIX: 
1.Fixed bug exposed in release 9.0.0 that prevented starting a new database.
2.Added persistance to Org Table display options

BUG FIX: 
1.Fixed bugs in formatting certain new data elements.

Enhancements: 
1.Added automatic creation of Organization Structure.
2.Revised OD1/2 processing to use new MQ message and MQ proxy in lieu of email.
3.Added support for 11 new data elements.

BUG FIX: 
1.Fixed bug exposed in release 8.0.3 that prevented importing email uploads.

BUG FIX: 
1.Fixed bug exposed in releases 8.0.0 and 8.0.1 that prevented uploads from being uploaded.

ENHANCEMENTS: 
1.Added new jobs/positions to OD1 and OD2 forms
2.Resequenced OD1 and OD2 forms to agree with paper forms

ENHANCEMENTS:
1.Converted all file references to UNC to allow network residency. 
2.Corrected numerous minor bugs and inconsistencies. 

ENHANCEMENTS:
1.Removed two loops in DB2000 which were checking for HQDATA completion too frequently, and interfering with HQDATA. 
2.Enhanced the spell checking in Merit Marks to do it globally or individually. 

ENHANCEMENTS:
1.Corrected encryption/unencryption in DB2000 during import roster/export of BDU. 
   Caused by difference in random number generator in VB6 vs. VB5.
2.Corrected bug in installation program allowing deletion of copied files. 
3.Added additional diagnostics to DB2000Diag.exe.
4.Added additional entries to Committee database resolving error with Dept R/Cs & Other Recs. 

ENHANCEMENTS:
1.Corrected problem in DB2000 regarding import of MM status update file. 
    It was updating the status display but erasing recommendation info.
2.Corrected problem in H701. It  threw an error after conversion of an old version database. 
    It was OK if no old version was found and it started a new version. 
   Also,  added seminars to the education summary.

ENHANCEMENTS:
1. Added MDAC_TYP to Installation to resolve certain Jet Engine resolution problems
2. Converted help file from .hlp to .chm to make help compatible vith Vista

ENHANCEMENTS:
1. This version is Vista compatible
2. Added support for diagnostic program 
3. Relocated all data files to \[My]Documents\DB2000V3 and all executables to \Program Files\DB2000V3  

ENHANCEMENTS:
1. Added support for Electronic Merit Marks
2. Revised Organization tables so they are now normalized and externally usable by RepWiz.
3. Added capability of copying any database field's data to a user defined field. 
   This includes the fields Squadron 1 (Squad1) and Squadron 2 (Squad2) fields that are included in the BDU.
4. Add to tags by member affiliation. Found in "Tools" menu in roster grid.
5. When naming a user defined field, the following characters that could disrupt SQL expressions are not allowed. 
    ! " # $ % & ' ( ) * + , - . / : ; < = > ? [ \ ] { | }
6. Merit Mark status can now be updated by an emailed file received after MM electronic submission.
7. Split Committee "National or District Conference Committee" into two separate committees.

BUG FIXES:
1. Could not delete a member with an existing office assignment.
2. Opening and closing help file while updating crashed program. This only occured if local mousewheel support was enabled.
3. Crash when changing the MM Submitting Officer for a D60, National, database. Also, change submitting officer window did not correctly display current assignment.
4. D & D printing module did not display a "foreign" member when using a district database and selecting a single squadron. "Foreign" is defined as a member from another squadron conducting an organizational task for the host squadron, such as course instructor. 

BUG FIXES:
1. Crash if wrongly formatted email address was entered.
2. In some name format data stuffer options, member with
   no grade and short first name could have first name removed. 
   Subsequent refresh would result in an error which terminated
   refresh process. Program continued to run.
3. Clicking on Send in the BDU update grid with no records in grid
   caused an error.
4. Clicking on OK in User Grid without a selected data stuffer list
   item crashed.

ENHANCEMENTS:
1. Added ADDRESS as the concatenation of current address1+address2
   fields to data stuffer list.
2. Added CITY/STATE/ZIP as the concatenation of City+State+ZIP to 
   data stuffer list. Zip+4 is edited to remove zero values.
   Following applies to both:
   a. Allows custom editting. 
   b. It updates changed records automatically when an address 
      component is changed or DA flipped.  This loses any custom 
      editing for the changed records(s) but leaves other records as is.
   c. The only way to refresh all records at the same time is to clear 
      User Field column(s) and reselect from data stuffer.
3. In data stuffer courses, if field is defined too small to hold data, 
   field is automatically resized.
4. The Roster Printer now uses content of row 3 in the label mode to find
   zip code for bar coding. This allows bar coding if the user selects a 
   user field as above for the label address.
   NOTE:
   This also allows making bar coded random labels by typing text into 
   each row.  To make a single label, tag a single record. Open D&D 
   printer and select label mode.  Place label text in each line 
   including zip in row 3. Select barcode.  If more than one member is 
   tagged, multiple similar labels can be made.
5. Cleanup function now includes marooned leading punctuation.

This revision corrects a single bug with bar code generation in the Down and Dirty print routine.

This revision corrects a couple of bugs including:
     Data duplication in the merit mark routine under certain conditions.
     Print overlap in the merit mark print routine.
     A program exception when using the Grade button.
     A program exception when attempting to start a new database.

Made a number of minor changes including:
     Fixed the Squadron name on the Merit Mark reports
     Added additional fields to the D and D Query Sorting list
     Added additional fields to the D and D printing facility
     Removed some erroneous fields from the DBxxx.MT template.

1. Added feature to enable bulk changes to the affiliation label of affiliated members.
   To use feature:
	a. Tag records that are to be changed.
	b. Select Rename Tagged Member's Affiliation under "Options button"
	c. Enter new name in dialog box.
	d. Click OK
	Note: Any tagged non-affliate records will not be affected

2. Simplified Roster grid layout by moving seldom used functions on menu under "Options" button

3. Modified D & D roster printer footer page layout.
   Added a check box to optionally flip the date and page number location on odd/even pages.
   This will allow the constant placement of page numbers in booklet mode and when printing in
   duplex mode. 

1. The following menu short cuts have been added:
	Ctrl+O	Open another database
	Ctrl+R	Open D&D roster print utility, full roster
	Ctrl+T	Open D&D roster print utility, tagged records
	Ctrl+Q	Open Roster Query utility
	Ctrl+W	Open Report Wizard

2. A major revision to the D&D roster print utility appears in this version.
	The user now has control over entire record content and can build each row from following items:
		Pre-formatted common items such as City/State/Zip and Name/Rank/Grade
		Database fields. (Fields used for database control are excluded from list)
		User provided text such as commas, spaces, and other constant text.
	The new print utility operates in four modes:
	Roster:	Up to 6 rows per record in up to 3 columns.
	Organization: Bridge and committee make up if entered in DB. (Same as previous version)
	Tab List: User can select items as above and each time he adds it is displayed dynamically
		tabbed from the previous entry. A list header and footer can also be displayed.
	Label:	Rows built similar to roster but for Avery 8160 label sheet.
		Zip barcode no longer needs a proprietary font. The barcode is now drawn graphically. 
		All references to the barcode font have been removed.
	5.5 X 8.5 paper size option.
	User selection of font.  Size may range from 8-12 pts.	
	Pre-formatted footer dates. (Date saved in page layout remains as saved)
	Optional Header/Footer and Column separator lines
	Page number on label sheet margin. A user request, handy for those that make address labels sorted by zip.
	Improved WYSIWYG page preview closer to actual printed page. Any user change is instantly seen.
NOTE:	Revised utility uses a new table for saved page layouts. Old table has not been removed so that
	layouts stored there are stll available if the database is ever opened in an older version of DB2000.

3. For dual address members, the cellphone number is now handled similarly to email address.  
	An offer is made to make it the same in both locations when change is made in either.

4. "Member Benefits Committee" has been added at N, D and S levels per request from national that districts and
	squadrons form such a committee. It was added to Admin. Dept. following the national structure.

5. Added "Member Since" to data stuffer. It shows only the year.