Topics Search

Setting a limit to number of entries of a form

Setting a limit to number of entries of a form
Views: 29
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:

Similar posts...


Using One Control to Limit Values in Another

Using One Control to Limit Values in Another Icon
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?

Read/Write privilege in Form. Also, how to preventing duplicate entries? Icon
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

Calculating the missing number Icon
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

Search form to fetch data of a specific data entry Icon
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

Cumulative Limit Concept Icon
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

Continuous form with option to save records or not

Continuous form with option to save records or not Icon
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.

Form with an unkonwn number of entries?

Form with an unkonwn number of entries? Icon
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?

User interface to search for records in table

User interface to search for records in table Icon
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

Access limit form rows

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

validation setting for duplicate entries

validation setting for duplicate entries Icon
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