All notable changes to this project will be documented in this file.
The format is based on Keep a Changelog and this project adheres to Semantic Versioning.
5.3.1 - 2023-12-05
- Missing instructions on using Age Range in New Event Wizard
5.3.0 - 2023-12-05
- Events can now have a range of ages, use - to separate, e.g. 14-16
5.2.2 - 2019-02-27
- Catch errors in MeetManager export where no time was entered for event
- Correctly close Meet Manager export file handle if function crashes
- Escape now closes Maintain Competitors Form
5.2.1 - 2018-05-24
- Reordered Ribbon to open on Entry Tab rather than Setup tab
- Recreated Main Menu screen Graphs in newer MS Graph version
5.2.0 - 2018-02-09
- Access x64 Support. Should now work on Access 2010+ x64.
- In Results entry pressing up and down arrow in name selection will bring up dropdown list of names, making it easier to select name without using mouse.
- When Importing students will verify Age is number and DoB is Date. Useful to remove header line.
- When choosing Sort by Place it would run the script to update Final Status generating an error if setting it to completed.
- Maintain Event Order can now start from 1 when no events have been numbered
5.1.4 - 2017-07-25
- Default location that Import Carnivals List views to Database directory.
- Changed Event Status from constant to enum
- Changed web ordering of Competitor Results based on result within heat level
- Add Results list was not updating after closing an event (Caused by code making forms resizable)
- Improved strong typing by declaring variables functions as types
- Changed Q and Response from globals to locally defined
- Started enabling Option Explicit for some forms to check variable declarations
- Warning if Web export does not fill in data due to faulty template
- Reset extra allocated Team points button with other reset options
5.1.3 - 2017-06-05
- Meet Manager Export was incorrectly formatting times > 60 secs
- Installer Desktop Shortcuts
5.1.2 - 2017-05-08
- Meet Manager Export. New Age -> Division mapping form to allow exporting event results to Meet Manager Track and Field.
- Database Schema of Carnival files modified to add Meet Manager Mappings.
- New field added in CompetitorEventAge: Mdiv.
- Adding text fields in schema for MeetManager added a default vale of False, instead of blank.
5.1.1 - 2017-05-05
- Competitor export for Meet Manager Swimming. Can now generate a RE1 Registration file for import into Meet Manager Swimming.
- Meet Manager T&F competitor only export was including duplicates.
5.1.0 - 2017-05-04
- Meet Manager Export. Can now generate a semicolon delimited file for import into Meet Manager Track and Field.
- Database Schema of Carnival files modified to add Meet Manager Mappings.
- New fields added in Miscellaneous: Mteam, Mcode, Mtop.
- New fields added in EventType: Mevent.
- Updated Sample Databases
5.0.2 - 2017-04-28
- Maintain Competitors listbox now supports type-ahead search
- Update MsgBox parameters to use names instead of magic numbers
- In Runtime prompt user to add Sports DB folder as trusted location
5.0.1 - 2017-04-03
- Updated UI font to Tahoma
- Fixed bug importing Carinval list from older data file
5.0.0 - 2017-04-01
- Released under MIT license
- Migrated software from Access 97 .MDB/.MDE to Access 2013/2016 .ACCDB
- Support for .ACCDB carnival files
- Ribbon Interface
- Temporary trusted location for new datafile to fix security warnings
- When started in Runtime mode adds current location as trusted to prevent future prompts
- CSS Support for HTML ouput
- Multiple Forms made resizable
- Adjusted Age Champions - All Div to use student age rather than event age
- HTML export VBA script instead of Report hooks. Start using CSS output.
- Multiple minor bugs relating to migration changes in Access 97 to 2013 code
- Changed the order of the unlimited lane reports back to name order (at request of HCC-V)
- Fixed an import problem for carnival disks with OPEN age competitors
- Added 3 column program summary.
- Changed look of forms to flat.
- Updated minor things.
- Fixed the reports that were showing Boys when it should have shown mixed.
- Changed the way EventAges are determined. Means the age champion report should work better.
- Fixed bug in determing places across all heats
- Added field to stop records from being generated for certain heats.
- Added removal of competitors from events
- Added checkbox to allow places to be calculated across entire final level, not just heat
- Completely redid how the places were calculated. Added checkbox to stop recalculation of places.
- Speeded up the promote competitors option
- Added quick add of competitor
- Add ID field
- Added permanent opening of linked database
- Added preview report from main menu
- Changed Age data type to Numeric
- Tidied up various routines
- Tidied up the statistical report generation
- Added jpeg graph export to web page generation
- Improved the import of carnival disks. Better error handling.
- Modified the Team / Event report slightly
- Fixed the Null error in Order competitor events
- Updated the version number
- Fixed the relationship between Heats and CompEvents so that updates would cascade.
- Fixed the bulk maintain of competitiors missing table bug
- Improved the PopupWindow option for reports by allowing it to remember its last position.
- Re-Created the installation routine seeing I lost the previous one.
- Fixed Utilities|Remove Empty Heats. Based on fields that no longer existed in original table.
- Modified Generate Reports: Maximises reports and added Popup Window menu option.
- Added New Setup Carnival form
- Added AddEvent Wizard
- Add various informational messages
- Checked all Msgbox dialogs
- Fixed control colours to refelct default system colours.
- Modified relationship creation: No longer deletes relationships if they all exists
- Ordered Competitors handled differently: Table held locally. Does not delete old but overwrites them.