S
Steven Lovell
Good Evening All,
i have a little problem and i wondered if anyone could help me
Background Information
Im the results secretary of a darts and dominoes league in the uk,
i have to produce various league tables weekly and various team stats once
every 4 weeks
Currently im using excel but to be honest with you its getting to the stage
that its becoming to much for excel,
so i have decided to have a go in access
i have a little knowledge of access setting up simple databases so designing
this one will become a massive task and im upto the challenge.
Current Info
The database set up consists of
1.A table for list of teams and contains test data of 3
teams...................for info this season is 13
2.A table for a list of players and teams and contains test data of 5
players ...........for info this season is 186
3.A table for a list of doubles dart matches and contains test data but
doesnt work see below
My problem at the moment is when on step no 3 above i want to select a team
in one box which is a drop down menu and in another box the players names
appears who only play for that team as set up in step 2, this is to happen 8
times on the table as there are 4 doubles darts matches and if the match is
won each player gets 1 point each and the team gets 1 point
i also have to set a table for 8 darts singles matches, 3 dominoes pairs
matches and 3 5&3's matches(a variant of dominoes)
Can anyone kindly help me in my problem in step 3
Regards
Steven Lovell
Also for info
some players play darts, dominoes and 5&3's
i have to record all wins for the above plus dart scores of 100 or more and
scores of 180
also produce weekly leagues tables for everything and produce team stats
monthly
also i produce all the above info on webpages and i upload them to the
internet so anybody in the league or the anybody on the internt can have a
look at them
the current excel file is nearly 17mb and consists of 16 macroes and 1
master macro which runs all 16 and when activated takes nearly 1 min to run
megga thanks in advance
Steve
i have a little problem and i wondered if anyone could help me
Background Information
Im the results secretary of a darts and dominoes league in the uk,
i have to produce various league tables weekly and various team stats once
every 4 weeks
Currently im using excel but to be honest with you its getting to the stage
that its becoming to much for excel,
so i have decided to have a go in access
i have a little knowledge of access setting up simple databases so designing
this one will become a massive task and im upto the challenge.
Current Info
The database set up consists of
1.A table for list of teams and contains test data of 3
teams...................for info this season is 13
2.A table for a list of players and teams and contains test data of 5
players ...........for info this season is 186
3.A table for a list of doubles dart matches and contains test data but
doesnt work see below
My problem at the moment is when on step no 3 above i want to select a team
in one box which is a drop down menu and in another box the players names
appears who only play for that team as set up in step 2, this is to happen 8
times on the table as there are 4 doubles darts matches and if the match is
won each player gets 1 point each and the team gets 1 point
i also have to set a table for 8 darts singles matches, 3 dominoes pairs
matches and 3 5&3's matches(a variant of dominoes)
Can anyone kindly help me in my problem in step 3
Regards
Steven Lovell
Also for info
some players play darts, dominoes and 5&3's
i have to record all wins for the above plus dart scores of 100 or more and
scores of 180
also produce weekly leagues tables for everything and produce team stats
monthly
also i produce all the above info on webpages and i upload them to the
internet so anybody in the league or the anybody on the internt can have a
look at them
the current excel file is nearly 17mb and consists of 16 macroes and 1
master macro which runs all 16 and when activated takes nearly 1 min to run
megga thanks in advance
Steve