Revision as of 21:44, 10 May 2010
Round Robin Schedule Creator Demo
Round Robin Schedule Creator Demo V1.0 - May 10, 2010
This is a demo database that allows the user to select a set of teams/players, and automatically create a round robin schedule (where everyone plays everyone else only once) for them, using VBA code.
The above attached file contains a demo database in Access 97 format and Access 2003 format.
The demo contains VBA functions based on VB6 code taken from the vb-helper website which was based on an algorithm described at the mathforum.org website. The functions create a two-dimensional array, representing the Round Robin Schedule for a given number of teams.
Once this array has been created, it is converted to records in a data table, allowing the user to view the schedule on a form and a report.
The VBA code is documented internally, including a code module called "modReadMe", which includes more extensive descriptions of the process.
This demo includes a code module of utilities, both of which can be found at The Access Web.
In the frmTournaments form, go to a new record to create a new tournament. Type a description of the tournament at the top of the form. Next, on the left side of the form, select the teams/players that will appear in this tournament. To add/edit the teams, double-click the combo box that you use to select a team.
Once the teams have been selected, click on the [Generate Schedule] command button to create your schedule. The VBA code behind this button is where most of the hard work is done. Your auto-generated schedule will appear on the right side of the form.
Once the tournament schedule has been created, you can print it out by clicking the [Print Schedule] command button.
--Doctor9 16:45, 10 May 2010 (EDT)Doctor9