Limiting the number if instances of an entry

A

Andrea_Hopwood

I am creating a database to book people onto courses. I would like to limit
the number of entries booked onto course number 1 to 12 people so that the
course does not become overbooked, is there a way of only allowing 12
instances of the number 1 in a field named "course number"?

I am not a computer expert so please can replies be aimed at "MS Access for
dummies".

Thanks,
Andrea
 
A

Andrea_Hopwood

Thanks for your response, however I cannot seem to open the database once I
have extracted it. The error message implies that the program cannot access
the data it needs through the file name supplied.

Is there any way you could describe how to do it, or is it too complicated?

Andrea
 
R

Roger Carlson

The data is in a separate table that is also included in the Zip file. You
need to relink the tables (using the Linked Table Manager) to the back-end
database.

The sample is a fully functioning training registration application, so
there may be other things of use in it for you.


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
A

Andrea_Hopwood

Thanks so much for all your help.

Maybe I'm being a bit slow, but I still don't understand how to limit the
number of people that can be enrolled on a course.

Andrea
 
Top