management and scheduling

[Shaun]

Hi all,

I was hoping some of you could be of some assistance. I'm looking for an
access DB to manage a sports team. The db needs to keep track of players
contact ino and which team in the club they play for. I also want to keep
history from year to year within a sub form on each player card. To be
honest this part was fairly easy to create. The part I'm struggling with is
the scheduling part. I want to have a form that will set each match on a
calendar. For example, I want to be able to enter the date/time,
location,Division,home and Away information. The tricky part it that
depending on the Division, I want it to create a list of players from that
division, then have a combo box with other options to determine if the player
will attend the match or not. The data set within the player list area would
then need to create a report(roster of those available or tentative). I
would also like to keep track of the score and who scored on this form for
reporting later on.

This sounds complicated. Hopefully someone can help.

Thanks!

 

[Paul Ballou]

I would suggest an Access Specific News Group for Help.
http://www.microsoft.com/office/com...mspx?dg=microsoft.public.access&lang=en&cr=US
--
Paul Ballou
MVP Office
http://office.microsoft.com/home
http://homepage.mac.com/paulballou/
http://www.ballousgiftshop.com

 

[Jim Aksel]

This is really just a tweak to the existing Contact Management database
template within Access. Start there
--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project