Results 1 to 2 of 2
  1. #1
    rb26dett26 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2016
    Posts
    8

    Swimming Pool Schedule with Limited Pool Space

    Hello,

    I am trying to create a database of swim teams that come to my pool. I have a 50 meter, 10 lane pool and I wanted to create something similar to my excel sheet that I attached. I currently fill in all the teams in their respected times and I have to create individual team schedules for each team.

    My goal is to make something in access that would let me choose:
    1. the team name


    2. team color
    3. time of practice
    4. number of lanes.

    Then I would have it to where a report would be created for each specific team within a month.

    The access DB should be able to see that a team has a certain amount of lanes and only a certain amount of lanes are open for specific times.
    Example - If team A has 10 lanes from 5-7am then team B cannot swim in that timeslot since 10 lanes are being used.

    I wanted to see if anyone has seen a similar database I could use as a reference. This would help my organization big time but I dont know how access would see a team block and let the user know how many lanes can be used.
    Click image for larger version. 

Name:	Pool Schedule Pic.JPG 
Views:	21 
Size:	138.5 KB 
ID:	38119

    Thank you in advance.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Scheduling/Appointment/Calendar database has been topic of numerous threads. Have you Googled or searched forum?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Calculations Limited
    By juriemagic in forum Database Design
    Replies: 2
    Last Post: 04-17-2015, 06:54 AM
  2. Form For Pool Calculations
    By Grayhat in forum Access
    Replies: 1
    Last Post: 01-02-2015, 03:37 PM
  3. Pool League
    By Crazybrit in forum Database Design
    Replies: 3
    Last Post: 12-01-2012, 01:34 PM
  4. Limited use
    By kevbetty in forum Security
    Replies: 1
    Last Post: 03-29-2010, 11:34 AM
  5. Indexes limited
    By DanW in forum Access
    Replies: 6
    Last Post: 11-12-2009, 03:12 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums