Revision as of 20:47, 10 May 2010
Round Robin Schedule Creator Demo
[Round Robin Schedule Creator Demo] V1.0 - May 10, 2010
This is a demo database.
NOTE: Please pardon the formatting (or lack thereof) - After much flailing around with the search box I stumbled across a link that explained how to create a new Wiki page, but I still haven't figured out where to find a template for what I'm doing.
The 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 a 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.
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