Setting a limit to number of entries of a form

Well I've got two tables / forms:
Course Details Table / Form and Booking Details Table / Form.
They are both related.
I want to make it so that the Booking Form can only allow 30 entries of students per course.
The course details table has a course ID and other stuff for the course.
The booking form has a booking ID, course ID and student ID (I also have a students table).

Sponsored Links:

Related Topics

Using One Control to Limit Values in Another
I have a combo box on a form that's pulling a large number of possible entries (items in an inventory) from a lookup table. Each entry belongs to one of several categories, and the number of categories is far fewer than the total number of entries. I would like to structure the form so that the user first selects the category from a separate combo box and then the choices in the item combo box would be limited to entries in that category. I'm having trouble discerning what particular mechanism I need to make this happen. Thank yo for your


Read/Write privilege in Form. Also, how to preventing duplicate entries?
I have a database that I would like my employees to be able to populate via a form I created.

Can I limit there read/write ability so that they can only add new entries and not accidentally delete things from the database.

Also, is there a way to make sure they don't enter duplicate data. I.e. Engineer 1 enters information for part number X, but tomorrow Engineer 2 goes to enter same part number X.

If they could see the database table, they could search and see if it had been entered already, but I don't want to give them access to the entire database. Ideally they would just beworking with a form and the form wouldn't allow them to enter duplicate entries in the part number field.


Calculating the missing number
I searched the archives and can't quite obtain the answer I am looking for.

I have a table that allows for unlimited entries, but it needs to have at least 2 entries per Person (already connected relationally in a one-to-many). I need a calculated control for the form that can state how many more entries the Person needs by counting the number of entries that are already in the table.

For example, PersonA has 1 entry and the control would state that 1 more is needed. However, Person B has 3 entries and the control would simply be blank.

I plan to use the control in both a form and also a report.


Search form to fetch data of a specific data entry
Basically I have a table which holds as entries specimens and actions taken on the specimens. Because of that, there could be multiple entries under the same serial number.

What I would like to do is have a search form, in which the user enters the serial number, and a list appears for all of the entries with that serial number.


Cumulative Limit Concept
I'm trying to understand how I could achieve the following goal:

Table 1:
Project Number
Approved Funding

Table 2:
Project Number
Accounting Date
Actual Value

Table 3:
Project Number
Accounting Date
Forecast Spend

Table 4:
Project Number

There will be multiple entries in each table for each project number. What I need to do is create a query (or series of) which will show me where for each project in table 4:

Where Actuals to Date (Table 2) + Future Forecast (Table 3) > Total Approved
Spend (Table 1)

And also which entry in the forecasting table causes the cumulative limit set in Table 1 to be breached and thus infer the date on which this will happen.

It's a bit more complicated than anything I've dealt with before so could


validation setting for duplicate entries
I have 2 columns in a table and both form a unique value together. How do I set up validation properties so that 2 entries in both columns cannot be identical


Continuous form with option to save records or not
Let me see if I can explain what I want to do. I want a continuous form that when open is empty. The user can then add any number of entries ( each record has 4 fields). I want the user to have the option to save or cancel the entries.

If they cancel the form will just be closed. If they save I want to save the entries into a different table, which will contain all the saved entries from each time the continuous form has entries that are saved. Each time the form is opened it needs to be empty.


Access limit form rows
How I can limit the number of row shown in access form?


User interface to search for records in table
I have a database with one table. The table has two fields, part number and tool number. The table is populated with data. I need to develop a user interface that will allow the user to enter a part number or a tool number and click a button to list all the entries in the table that match the number entered by the user. See the attached image, this is what I want the form to look like. The table should populate with the matching entries. I have no idea where to start. Do I create a query or a form or a report


Form with an unkonwn number of entries?
guys, here is the case:
I want to create a 'Purchase orders' Form. the form would look something like this:

Item number. Item description. Item quantity. other notes.

now, the purchase order could contain multiple entries(Items), but not specific to a certain number. like for example, in a single order you could place one item or two or five or ten. I could create a specific number of text boxes for the user to enter a certain amount of items, like seven or ten but this would be inefficient, non-practical and would clutter the form.

So, what would be the best practice of creating such a form?


Limit Records
Is there a way to limit the number of records entered in to a form (or table)?


Question about Validation Rules
I have a data entry database and I am trying to assign a validation rule to one of the text boxes that will limit entries to the following format: L099999. This allows users to enter one letter, followed by anywhere between one and six letters (only one letter and one number is necessary). This works fine. My problem is that I also want to allow users to input a dash (-) followed by at least one number. So in other words, I want users to be able to enter one letter OR one dash, followed by at least one number (and optionally five more numbers). Any way to do this


Assign same project number to 500 entries everytime a button is clicked.
When a user click on a button "send" then it should check the first 500 entries whose Proj_no is null and asign a unique project number to those 500 entries. Suppose when a button is clicked then for the first 500 entries the project "P1" is assigned. When again the button is clicked then the next 500 entries "P2" is assigned. and if the button is pressed and the total number of entries are still less than 500 whose proj_no is null then a message should appear "The number of case are less than 500 yet" and nothing should happen


User interface to search for records in table
I have a database with one table. The table has two fields, part number and tool number.

I need to develop a user interface that will allow the user to enter a part number or a tool number and click a button to list all the entries in the table that match the number entered by the user.

this is what I want the form to look like. The table should populate with the matching entries.


Changing number of digits in Autonumber ID
My first post here in the forum.

I have "inherited" an access database from a colleague, and after a while a problem occured.
The database is frequently accessed by a large number of users, some of which creates new entries.

For the last few days, new entries have been assigned Autonumber ID's with nine digits although all old entries have only four.

I am the only person able to directly access the database (everyone else does so through Excel) and I have not changed anything.

Any ideas on how I can change the 1500 old and 50 new entries into common format with regards to Autonumber ID?


Text limit in a form Access 2010
I am creating a form in Access 2010, and would like to set the maximum number of characters that can be typed into this entry field.

How would I go about doing this?

For Example: How would I limit an entry on a form so that you could enter as many characters up to 30 but not exceed 30?

Same with numbers


Is it possible to Limit Records in a Form
Beloved Gurus, Is it possible to limit number of records in a form? e.g. I want to enter only five records and not more than that?


Consecutive ID numbers
When I create new entries, access automatically assigns ID numbers. However, when I delete entries, the ID disappears and the next entry jumps an ID number.

Basically I want all my entries to have consecutive numbers for practical purposes. How can I do this?

I can't manually change ID number because it's part of the autonumber feature(I think!). Is there any way of recalibrating/adjusting ID numbers?


Setting subform to add mode while main form is in edit mode
Is it possible to have the subform on a main form open in add mode while the main form is in edit mode? I have a main form that shows the first and last name of my drivers while the subform is for entering a date and number of hours on duty for that date. The subform is beginning to have a large number of entries and I have to scroll down to the last entry to begin entering data.


Consecutive ID numbers
I have created a database which seems to be working ok. When I create new entries, access automatically assigns ID numbers. However, when I delete entries, the ID disappears and the next entry jumps an ID number.

Basically I want all my entries to have consecutive numbers for practical purposes. How can I do this? :/

I can't manually change ID number because it's part of the autonumber feature(i think!). Is there any way of recalibrating/adjusting ID numbers