How do I set a limit to the amount of records can be entered in an access table?

[aidan24969]

I have made an access database and need to be able to limit the amount of entries for specific attributes.

This is the contents of the table:
Student Subject Enrolment (tblStudentSubEnrol)
• Student Code (tblStudentDetails) (Relationship)
• Subject Code (tblSubjects) (Relationship)
• Date of Enrolment

I need to be able to limit so there can only be a minimum of 3 and a max of 4 repeated student codes within the tblStudentSubEnrol table.

I also need to be able to have a limit of 25 repeated subject codes in the tblStudentSubEnrol table.

Anyone have any idea how this can be done?

[SagarJaybhay]

First take count from your table if it satisfy your condition then enter data into table if not then simply reject the entry. After make new entry simple increment value of count. I think it will solve.

[twinnyfo]

Aidan24969,

Welcome to Bytes!

Your main challenge will be with the “minimum” requirement—which is impossible. How do you enter the first two while still meeting that first, minimum requirement. So, obviously, this check is something that you must do after the fact, after all enrollments are complete.

However, SagarJaybhay is on the right track. Every time you plan to enter data, you examine the validity of the data. If it meets your required criteria, add the record to the Table (I would recommend using an unbound form, so that you don’t accidentally add records that violate your rules).

One correction, though. Once the record is added, there is no need to “increment the count”, as your validation rules prior to adding the record do the counting. There is no need to save any counted values—this is a waste of DB resources.

Hope this hepps!