Go Back   Access World Forums > Microsoft Access Discussion > General

Thread Tools Rate Thread Display Modes
Old 09-11-2019, 03:08 PM   #16
Newly Registered User
Join Date: Sep 2019
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
jane4587 is on a distinguished road
Re: Limiting Class Size

Pat Hartman,
I have every intention of building this thing myself I just need help in learning how to do it. Even if its a youtube video but I have tried for 5 years building it and learning this database myself and now I have reached the point i need help.

In response to your question about class size: I want to add a 7th child even if the limit is 6. No the student limit is not a field in the class table however I can add it if need be. Basically I have every class we offer and the times in 1 table. They are not separate tables. I have attached a screen shot of my roster table. The childs name auto populates to this table. Will this work for what you mentioned as my "roster" table in your previous message? I want to keep a record of every class lets say child john smith attends even if they drop out of that class i want a record of it. I want to set a limit for kids who status in the class is current. this way i only see kids who status is current and not dropped or something else.
Attached Images
File Type: png Annotation 2019-09-11 180444.png (88.5 KB, 8 views)

Last edited by jane4587; 09-11-2019 at 03:14 PM.
jane4587 is offline   Reply With Quote
Old 09-12-2019, 07:44 AM   #17
Pat Hartman
Super Moderator
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,402
Thanks: 15
Thanked 1,625 Times in 1,543 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Limiting Class Size

If ALL class sizes are ALWAYS the same, you could use a literal value for class size. I don't recommend it but you could. If class size varies by class, then you really need to add a field to the class table so you can hold the limit for that particular class.

If classes are limited in size, then how can you just add more students? If you can add more students regardless of whether or not the class is full, what is the point of maintaining a limit in the first place? It might make more sense to let a human decide rather than the computer. In that case, your roster form can display the number of students currently enrolled and a real, physical maximum beyond which you cannot go. Then the human can decide whether to add the student or start a new class.

A picture of your schema would be more useful. I'm pretty sure that your tables are not correctly defined to do what you are asking to do. Open the Relationships window and arrange the diagram so that all tables are visible and all the fields are showing in every table. It is important that we see everything, if you can't make that happen, then uploading just empty tables will give us a starting place. If you want help moving stuff around and actually normalizing the schema, you WILL need to upload a database because no one will want to retype the whole thing.

Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
System error "&H80040111 (-2147221231) Class factory cannot supply requested class davidb88 Excel 2 06-30-2014 05:03 AM
Need help implementing property of base class in derived class. papadilbert Modules & VBA 6 12-01-2011 06:11 AM
Correct syntax to make Class Function Private yet callable by instances of Class mdlueck Modules & VBA 4 11-07-2011 07:32 AM
Limiting a text box size yhgtbfk General 5 11-17-2004 06:15 AM
[SOLVED] Limiting field size of a form variable tbasha Forms 2 09-20-2000 12:56 PM

All times are GMT -8. The time now is 03:44 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World