Tennis Player Availability

[aldeb]

I am a tennis coach at a local college. What I am trying to do using access is:

I want to enter my players names, classes and class time. That way I can find out when a player is available for practice. I do not know how to accomplish this. Classes start at 8am and end at 5pm. They are usually in one hour increments. I would love some help on how to enter the data and then use queries to see who is available on a certain day at a certain time. Thanks for any advice.

 

[StarGrabber]

Hi aldeb,

you'll find attached my approach to your task.

If you create a form to select the player names and to display the desired result, you should use a combobox with two columns. The first one with the ID and width = 0 (that is invisible). The second one with the names and with the width of the entire combobox. Then use not the query "qryAvailabilityPerSurname" but "qryAvailabilityPerPlayerID". In the criteria field you should replace [Enter a player ID] by [Forms]![YourFormName]![YourComboboxName].

Good luck.

 

[aldeb]

Thank you so very much for the zip file. I am really excited to check it out. I only have Office 2003. Is there any way you can convert this for me so I can try it out? Thanks again.

 

[aldeb]

I have Office 2007 so I installed that and will give it a try. Thanks so much for your help.

 

[StarGrabber]

Access 2007 and 2010 have the same file format so it should work. For use with the 2003 version I've attached a converted file.