Bug Fix:
1. Fixed bug where when the main screen was maximized the grid views overflowed screen hiding scrollbars.
Changes:
1. Cleaned up messy and redundant old DB update process. No update is attempted on databases 
    predating the major restructuring of organization tables in 2008
2. Took Microsoft Dialer.exe path from MiscData table and put it in the registry. 
3. Database tables "Addin", "Formsaddin", "MiscData" and "Sjob" are now redundant. 
    Emptied the tables and removed all references thereto. Left the empty tables in DB so that a version 9.6.4 DB 
    will not throw errors on older DB2000 versions. "Sjob" table was to support printing squadron OD-2 info with 
    the "Down & Dirty Print Utility” in district databases.  Info is now obtained directly from "HQref.mdb/Rosetta" 
    and "DB2000\MemberCom" tables which should have been done in the first place. 
4. Made a new MT database template and resolved errors in the HQREF.mdb USPS organization job codes.
5. Added updater privilege filter to district directory options.
6. Preset to download D60 roster same as any other. (should it ever becomes available.)
7. Made default screen size 1024 X 768 pixels

Bug Fix:
1. Fixed errors in OD1 and OD2 process

Bug Fix:
1. Fixed errors in organization structure process

Bug Fix:
1. Error copying records to another database
2. When printing the OD-2 form printer fed an extra page.
3. Error ending program if attempting to add a name to the organization with no member selected. 
4. Error when downloading an update directly after uploading an OD-1,2 change.
Features:
1. Added JavaScript to communicate with web server for the latest program version.
2. If DB2000 could not find it's URL list it could not communicate with the server. This is caused if the file "HQREF.MDB" was not updated.
Added an emergency URL linking to the web "Downloads" page so that "HQREF.MDB" could be restored from DB2000.
Misc:
1. Added "Communications Committee" to the secretary's dept at National level.
2. Added help menu reference to BCA
3. Added help menu reference to check for updates.

Bug Fix:
1. Corrected another bug causing a General Error 9, Subscript Out of Range when clicking on the Merit Mark Review/Submit button.

Bug Fix:
1. Corrected a bug causing a General Error 9, Subscript Out of Range when clicking on the Merit Mark Review/Submit button.

Revisions: 
1. Added beep sound to all user-editable fields when the field length is exceeded.
2. Clarified password instruction text in Authorization dialog
3. Added user defined affiliations to the selection list in Affiliates dialog.
4. Revised email test display in "Comm" grid..
5. Revised help file.
6. Revised the MM submission form to only provide electronic submissions. 
    The printed submission are removed. Provision is made for entering an email 
    address for drafts independent of the commander.
7. Included MM printing under the "Reports" menu on the main screen for
    record purposes only..
8. In OD-2 form, made the "Export New Watch" feature non-optional once selected. 
    Clarified the control button captions and tool tips text for better direction.

Bug Fixes:
1. Refreshed "duplicate jobs" dialog in roster update to avoid inadvertent overlays. 
2. If in  "duplicate jobs" the "Update HQ" option was chosen it caused an error.
3. Fixed where no spouse name is defined could still assign spouse gender.

Revisions:
1. Completed move of system to USPS.ORG
2. Corrected bug that had Import looping forever on import of an email roster

Bug Fixes:
1. Corrected recently introduced bug that prevented menu reconfiguration following start new database.

Revisions:
1. Removed addin and forms feature which allowed other program developers to have DB2000 launch them from it's menu structure.
2. Integrated HQ-102 Form that was a separate program. Made it available to updaters only.
3. Revised the OD-1,2 forms to simplify presentation. Made it available to updaters only.
4. In dual address feature, supressed  "Add to Next Upload" message unless user is an updater.
5. In DB2000 roster printing utility:
a. Grouped the hard to find organization fields at the beginning of the field list. 
b. Improved the organization list query options.
6. Optionally display icon or text on the grid view buttons.
7. Display "student" members with their certificate numbers lower case. Bar them from holding office or getting merit marks.
8. Improved the functionality of member dropdown lists.
9. Allowed retention of member status when copying records from a squadron DB to same district DB.
10. When adding members to positions in the organization, clicking on the name of a listed committee member positions the list box. 
      This is handy when changing the members place on the committee which requires that he first be removed and then reassigned.
11. Removed the "Quick Assign" option on the organization grid. It was redundant and not all that quick.

Bug Fixes:
1. In version 953, in the exit program routine, "cancel" option was not working.
2. From a user error report, created a trap for "CreateObject" in ChangeDB operation. 
3. Suppress "00000000" to "" in module lists.
4. Corrected an SQL error in the User Field Grid "Copy Existing Field to User Field" option.
    The statement failed on field name beginning with a number. eg "2009_MM"
5. OD-1,2 job "HQ" flags were not being reset after a successful upload. This resulted in persistet requests to "save changes" messages when leaving OD form..
6. When saving an organization list page layout in the D & D roster printer utility the database SQL was not saved. This resulted in a request for a query 
    when a saved page was retrieved. Since the original query was unknown this could result in a different data presentation.
7. Corrected recently introduced bug which failed to update database timestamp prior to calling RepWiz.

Bug Fix:
1. When printing organization pages in the "D&D Roster Printer", the bridge officers 
   did not sort correctly if one or more positions were unfilled.

New Features:
1. Added YouTube.Com video index and access to the new DB2000 demonstration movie library.
2. Added email address box in the "Authorization" dialog so that with a new DB2000 
   installation (empty database), when requesting an email roster update, the on-line request will 
   be automatically filled. This is interlocked with the user's email address once the database is 
   established. Not needed for MQ update.

Changes:
1. Revised the DB2000 help documentation to reflect menu structure changes made in 9.5.2 and 9.5.3 revisions.
2. Extended help for merit mark topic.
3. Revised the "Historian Form" help documentation.

Bug Fix:
1. Changed to handle passwords for 4-8 characters.
    Previously password had to be 6 characters or it would fail on download.

Process Change:
1. Added Sea Scouts to the Quick and Dirty member type selection.

Process Change:
1. Removed URL maintenance from the Settings Menu in preparation for moving functions
   from accurecord.com to usps.org. URLs are now in HQREF.MDB.

Bug fix:
1. Fixed error in importing SeaScout indicator.

Bug fixes:
1. Fixed errors in password entry routines.
2. Fixed error in emailing when only one address used.

New feature:
1. Added explanation of email test status codes. Accessible by double-click.
Bug fix:
1. Fixed errors in OD-1 printed report.

Bug fix:
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 fix:
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 feature:
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.