Project Detail

Description

Number Mach

1) Visual Basic 4
2) Must supply source code and rights included in price
3) 3 screens
4) .mdb database - 2 tables

System is to store and compare “Chosen Numbers” numbers to “Drawn Numbers”

Table 1 – person's name and 6 numbers chosen

Table 2 – draw date and 6 numbers drawn

Screen 1 - Display all names and associated “numbers chosen” – fields for adding, modifying or deleting names and numbers - print option

Screen 2- Display all dates and associated “numbers drawn” – fields for adding, modifying or deleting names and numbers - print option

Screen 3 – Display all names and number of “numbers chosen” that match “numbers drawn” - print option

Three printed reports

Associated menus, menu bar, navigation commands etc

Scenerio:

3 people sign up and choose 6 numbers each (numbers are 1 – 99)
The names and their chosen 6 numbers are entered into screen 1
The program adds them to Table 1
The name and numbers are displayed on the screen 1 as they are entered
Screen 1 should always show all the people entered (up to 250 – may require scrolling in list box or something)
Screen 1 must allow for adding, changing and deleting names and numbers
Screen 1 provides a print option to display the list of names and chosen numbers on a report


A draw takes place
The date of the draw and the 6 numbers drawn are entered into screen 2
The program adds the draw info to table 2
The dates and the numbers drawn are shown on screen 2
Screen 2 should always show all the draws entered (up to 250 – may require scrolling in list box or something)
Screen 2 must allow for adding, changing and deleting dates and numbers
Screen 2 provides a print option to print the list of dates and drawn numbers on a report

Screen 3 lists names and chosen numbers along with the number of chosen numbers matching the drawn numbers.
Screen 3 should list the names in the order of the number of matches – most matches first.
Screen 3 provides a print option to print the names, chosen numbers and number of matches on a report


MATCH LOGIC
The number of matched numbers for any given name should be cumulative over all the drawn numbers. A number should only be considered matched once

EXAMPLE

Person p1 chooses numbers 1 2 3 4 5 6 as their 6 numbers
Person p2 chooses numbers 2 4 6 8 10 12 as their 6 numbers

On date d1 the numbers 1 3 5 7 9 are drawn
On date d2 the numbers 2 5 9 16 32 are drawn

Displaying screen 3 after entry of all the data should show:

P1 1 2 3 4 5 6 4 matches

P2 2 4 6 8 10 12 1 match