UtterAccess HomeUtterAccess Wiki

Welcome Guest ( Log In | Register )

Custom Search
Edit Discussion
> Round Robin Schedule Creator Demo    
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 both Access 97 and Access 2003 formats.

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 thought process behind the table design.
This demo includes a code module of utilities, both of which can be found at The Access Web.

Basic Instructions:

  • 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

Edit Discussion
Custom Search
Thank you for your support!
This page has been accessed 12,418 times.  This page was last modified 01:13, 7 February 2012 by Jack Leach. Contributions by doctor9, Ace and Cpetermann  Disclaimers