Go Back   Access World Forums > Microsoft Access Discussion > General

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 09-11-2019, 03:08 PM   #16
jane4587
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
 

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 10:34 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


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