Hi all,
I have a database in microsoft access based on a video store. What I need to be able to do is limit the number of entries/ videos that a customer can take out i.e set a limit of maximun 3 videos per night.
I have built a unbound text box in a form that the user can input the customerID, click open which opens a form with the customer details, like name, address, etc plus a subform with viedo name, certificate etc. What I need is to be anle to limit the number of possible videos entered to a maximun of three. i.e. once the third video has been entered Access won't allow another. Plus is there a simple way of doing this without using VBA.
Hope someone can help. Mank thanks in advance
I have a database in microsoft access based on a video store. What I need to be able to do is limit the number of entries/ videos that a customer can take out i.e set a limit of maximun 3 videos per night.
I have built a unbound text box in a form that the user can input the customerID, click open which opens a form with the customer details, like name, address, etc plus a subform with viedo name, certificate etc. What I need is to be anle to limit the number of possible videos entered to a maximun of three. i.e. once the third video has been entered Access won't allow another. Plus is there a simple way of doing this without using VBA.
Hope someone can help. Mank thanks in advance