Showing more than one record

brave07124

Registered User.
Local time
Today, 14:10
Joined
Dec 26, 2013
Messages
11
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 just 1 page of the form without using the navigation buttons to move between records.

Here is the scenario:
I need to design a database system for students to choose their modules.
Please find attached the relationships diagram. Relationships Table.jpg
Each student needs to choose exactly 6 modules and I want the student to input all their 6 choices on 1 page of form, instead of using the navigation buttons to switch to a blank record to input each module.
 
Last edited:
Use a query with "SELECT TOP 6" clause for the form's record source.
But maybe I misunderstood your question.
 
Use a query with "SELECT TOP 6" clause for the form's record source.
But maybe I misunderstood your question.

I want to show six records on each page of the form, not just showing only the top six records.
 
Play with the Form header and footer sections height until obtain the desired result.
And the form should be a Continuous Form.
 
Last edited:
Play with the Form header and footer sections height until obtain the desired result.
And the form should be a Continuous Form.

Actually, I want to be able to enter 6 new records on just 1 page of the form.
Is it possible?
 
Use a query with "SELECT TOP 6" clause for the form's record source.
But maybe I misunderstood your question.

I clarified my question on the top thread.
Have a go at solving it please.
 
Your question still does not make sense. What is the purpose of entering six (identical?) records at once?

Have you tried a Continuous form, like Mihail suggested? In what way does that not meet your needs?

Help us help you. Be specific and concrete.
 
Your question still does not make sense. What is the purpose of entering six (identical?) records at once?

Have you tried a Continuous form, like Mihail suggested? In what way does that not meet your needs?

Help us help you. Be specific and concrete.

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 1 page.
Using Mihail's approach, there is only one blank record.
 
Last edited:
You have provided very little background to your question and only asked if it is possible, so the answer is yes.

If you want to know how to do it, which you haven't asked, then you need to explain what your form looks like and your table structure relating to the form- this comment
I want the user to enter 6 new different records on just 1 page of the form without using the navigation buttons to move between records.
doesn't make sense - you can just disable the navigation buttons and set the form cycle to all records or current page - navigation buttons are only really required for single forms, not continuous or datasheet forms.

.
 
...But maybe I misunderstood your question...

Actually, I think everyone has!

...is it possible to have the form show a specific number of blank records, say 6, on each page of the form?

The user wants 6 new, 'blank' Records to be visible, which really isn't possible. You could generate n number of Records, with some sort of incrementing ID number, but you cannot display multiple completely 'blank' Records. The reason everyone is confused, I think, is that the idea is simply so 'out there!'

Linq ;0)>
 
You have provided very little background to your question and only asked if it is possible, so the answer is yes.

If you want to know how to do it, which you haven't asked, then you need to explain what your form looks like and your table structure relating to the form- this comment
doesn't make sense - you can just disable the navigation buttons and set the form cycle to all records or current page - navigation buttons are only really required for single forms, not continuous or datasheet forms.

.

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.
 
Actually, I think everyone has!



The user wants 6 new, 'blank' Records to be visible, which really isn't possible. You could generate n number of Records, with some sort of incrementing ID number, but you cannot display multiple completely 'blank' Records. The reason everyone is confused, I think, is that the idea is simply so 'out there!'

Linq ;0)>

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?
 
what is the appropriate approach so that students can enter 6 modules on 1 page of form?
This is another question so, the answer is DCount() function.

Pseudocode:
Form.AllowAdditions= (DCount(bla bla)<6)
 
Is the below what you are looking for?
attachment.php
 

Attachments

  • 6Records.jpg
    6Records.jpg
    43.8 KB · Views: 130
This is another question so, the answer is DCount() function.

Pseudocode:
Form.AllowAdditions= (DCount(bla bla)<6)


The Access Help says Form.AllowAdditions Property is of Boolean data type.
 
Yes, very similar to what I have in mind.
How did you do that?
By using a Temporary table in which 6 records are insert from code when the form is loaded. And setting the form's allow additions property to no.
Then you can run an append query to transfer the values into the table you use, when the form is closed.
Code:
Private Sub Form_Load()
  Dim dbs As Database, x As Integer
  
  Set dbs = CurrentDb
  dbs.Execute ("Delete * From TempTable") 
  For x = 1 To 6
    dbs.Execute ("INSERT INTO TempTable ( RecordNo) " _
    & "Values(" & x & ")")
  Next x
  Me.Requery
End Sub
I've attached the database.
 

Attachments

If you are so skilled, why you ask ?
My AllowAdditions IS boolean. Can you believe that ? :confused:

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

Users who are viewing this thread

Back
Top Bottom