Search results

Hi Please find attached the database. Under the subroutine - Private Sub Command1_Click() , I use 14 If ... then statements. I originally wanted to use a loop to do the job. But I cannot see how. Can anyone see how a loop statement can be constructed or how to shorten the tediously long code...

I can see how the AllowAdditions is boolean now. There is a comparison operator behind DCount () function.

Yes, very similar to what I have in mind. How did you do that?

The Access Help says Form.AllowAdditions Property is of Boolean data type.

I updated the top thread and presented the scenario there. Under the context of the relationships table attached, if it is impossible to have 6 blank records to be visible, what is the appropriate approach so that students can enter 6 modules on 1 page of form?

I stated the scenario and attached the relationships table on the top thread. I am stuck because I want the user, or student, to be able to enter 6 new different records on 1 page of form; but I don't know how I can set up the form to meet this end.

I want the user to enter six new different records without using the navigation buttons to move between records. I tried what Mihail suggested. I could show 6 existing records on 1 page. However, what I need is to show 6 blank records on 1 page so that the user can enter 6 different records on...

I clarified my question on the top thread. Have a go at solving it please.

Actually, I want to be able to enter 6 new records on just 1 page of the form. Is it possible?

I want to show six records on each page of the form, not just showing only the top six records.

Hi After setting the source of a from to a table, a form shows a blank record and allows you to input one row of record at a time. But is it possible to have the form show a specific number of blank records, say 6, on each page of the form? I want the user to enter 6 new different records on...