The Certificate Module provides an easy to use interface that allows Scrutineers and Competition Organisers the ability to design their own Place Certificates.
This module uses Microsoft Access’ ability to ‘Link’ data tables between Access Databases. This documentation will describe how to link a copy of the Certificate Module to the main DanceScore application.
When a result is compiled in the DanceScore application, either at the time of processing an Item or reproducing a result that has already been processed, a table called PlaceCertificateReport will be populated with the details of that result. This table is shared between the DanceScore application and the Certificate Module allowing the DanceScore application data to be seen (& used) by the Certificate Module.
This Certificate Module is supplied in the .mdb file format. This means that it is unlocked and free for you to change any of the Reports or code behind the Reports providing the ultimate in custom automation.
This module comes with some Certificate Reports already installed. These are to demonstrate how Certificates can be produced. Using the Copy and Paste function you can copy and modify these Reports to create new ones.
There are no limitations to the number of Certificate Reports you can store in your Certificate Module. Reports can be easily transferred using Microsoft Access’ External Data function. This means that you can create and customize as many different types of Certificates as required.
The Main Menu is similar to main DanceScore appliaction with the menu buttons on the left hand side.
Print All Certificates The ‘Print’ button will cause the program to check that there is data in the linked table and then open and print the certificates (selected report) that you have selected in the ‘Options’ section of the program.
Preview All Certificates Instead of printing the Certificates (selected report) as above, the ‘Preview’ button will display the Report on screen. This allows the operator the advantage of using the Windows Print Dialog Box to print any page to any attached printer.
Auto Print When the Auto Print button is engaged any Certificate data that is generated from directly processing an Item will trigger the printing process. When data is generated form the 'Results Menu' the Auto Print will not trigger.
Reverse Print Certificates will sort in reverse order.
Custom Certificate This function gives access to the data fields used in the linked table which allows for the quick printing of a Certificate using the current template.
Tutorial Explanation as to the functioning of the Certificate Module.
Options Button The Certificate Module’s ‘Options’ allows you to configure a Lookup table which enables easy selection of all the Reports you have made.
Note: This documentation assumes the use of Microsoft Access 2007 or above. It is also assumed that the user has a basic knowledge of the DanceScore Competition Module.
Download the module from the Quick Download link on the Welcome Page and place it in a convenient folder of your choice. In normal operation this module should be in the directory where you are using the DanceScore application, however every installation is different. Double click on the file to open the module; you should see the following screen.
Should you get an error message like below and not the 'SPLASH REMINDER' you need to follow the instructions for linking the shared table with a DanceScore application. Once this is done the Certificate Module should be closed and restarted.
As described earlier, all the data that is used for printing the certificates is passed through the Linked Table named … PlaceCertificateReport.
On the left hand side of the screen you will see a list of Access Objects. The third table from the top, the “PlaceCertificateReport,” is the one we must link to the DanceScore Competition Module.
In most circumstances the Certificate Module will be running on the same computer as the Competition Module. Both modules can be run at the same time and will share data in real time. Whenever a Final is compiled, Event data is immediately transferred to the Certificate Module.
However you can run the Certificate Module over a network from any computer provided you can ‘see’ the DanceScore Competition Module.
Once a Certificate Module is linked to a Competition Module it will remember that link and reconnect automatically on restarting.
Right Click on the PlaceCertificateReport object to access the context menu;
Click the Linked Table Manager icon at the bottom of the context menu, this open the Table Manager dialog box.
There is only one Table in the 'Linked Table Manager', tick the box next to the Table. Also tick the 'Always prompt for new location' box at the bottom of the Manager. Now Click 'OK'.
This linked table will remain active provided this Certificate Module can ‘see’ the Competition Module it is linked with.
Clicking on the ‘Options’ button on the Main Menu will open the above screen. From here we select the Certificate Report we want to use and the ‘Custom Text’ fields.
The Program needs to know which Certificate you want to print. It does this through the Certificate Style dropdown box.
In this box you will program a list of Certificate Reports. You can then select any of the Reports listed at any time.
There is also a ‘Preview’ button that will compile the selected Report with some test data.
When you create a new Certificate Report you will need to add its’ name to the Certificate Style list so that it can be selected.
To edit the Certificate Style List click on the ‘Edit List’ button.
The ‘Edit List’ button will open the lookup table for the Certificate Style. As you can see there are three parts to the lookup table.
1. Number This is the identifier number for the Report and it sets the order in which the Certificate Reports are displayed in the dropdown box. The number must be unique, no duplicates.
2. Report Name This is the name of the Report as listed in Access. If this is incorrect then Access cannot find the Report and an error will occur.
3. Report Description In this field you can type whatever description is required to identify your Reports. This can be a maximum of 255 characters and is purely for your reference.
Custom Text Fields At the bottom of the ‘Options’ screen there are three Custom Text Fields which are used for information that is global to all Certificates. It is your choice, you can use any or none of these Custom Text Fields.
To better explain let’s have a look at Report Number 5 named ‘A5 with Logo’.
This Report uses all three of the Custom Text Fields. In this case the two at the top are for the Competition Name and Competition Venue, while the ‘Custom Text 3’ field is used at the bottom for the date.
The DanceScore Competition Module
When any Final is compiled, whether it be from the ‘Live’ system or from the ‘Print’ menu, DanceScore will populate the ‘PlaceCertificateReport’ table. The ‘Place Certificate’ tab in the Competition Module’s Options allows you to change how the ‘PlaceCertificateReport’ table is populated. Don’t get confused. The above screenshot is from the Competition Module.
Swap Competitor Names
When the ‘PlaceCertificateReport’ table is populated the Names of couples are saved as they are listed in the Competitor Database. DanceScore will also split those names into two parts and save these. One will be the Gent’s name, the other the Ladies.
DanceScore does this by identifying the “ & “ that joins the Gents and Ladies names together and then splits and saves them to the ‘PlaceCertificateReport’ table. This gives you the choice of using either the joined or separate names when designing your Certificates.
DanceScore will automatically create a record in the ‘PlaceCertificateReport’ table for each separate name. This means that where there are two names, two Certificates will be generated, and where there is a single name only one Certificate will be printed. Many competitions are a mix of DanceSport (couples) and Social (single competitor) events.
The ‘Swap Competitor Names’ function will automatically generate one Certificate for the Gent, (man’s name first), and then one for the partner, (ladies name first).
NOTE: Competitor names must be separated by “ & “ for the automatic selection to work. In other words, space&space , must separate couple names.
Print All Places or Select a Print Range
There are times where only a specific range of Certificates are required. For example I have seen competitions that the Organisers have supplied trophies for the first three Places and only want printed Certificates for places 4 and below. Also there are competitions where Certificates are required for only the first 3 places.
Of course it is possible to use the Windows Print Dialog Box to select specific pages for print. While the Print Dialog Box is handy for fixing problems it can be a little clumsy for printing the volume required for Certificates. A better solution is to specify a Place Range to print and this is done in the DanceScore Competition Module.
Here you can simply tick the ‘Print All’ tick box which will generate Certificates for all Places.
If you want to select a Print Range you must unselect the ‘Print All’ tick box. Now you can set a Start Place and a Stop Place.
If the Stop Place is set to 0 (zero) all certificates from the Start Place will be generated.
As in the above examples, if you wanted to print Certificates for 4th place and below you would type 4 into the Start Place and 0 into the Stop Place. If you only wanted to print the first three places then you would type 1 into the Start Place and 3 into the Stop Place.
REMEMBER: The Swap Competitor Names and Select a Print Range options are a function of the Competition Module not the Certificate Module.