comboboxes multiple notinlist event???

[andy49]

Hi all



I currently have this:

Private Sub cboTopicQ01_NotInList(NewData As String, Response As Integer)
Call AddNewtoList(NewData, Response)
End Sub
Private Sub cboTopicQ02_NotInList(NewData As String, Response As Integer)
Call AddNewtoList(NewData, Response)
End Sub
Private Sub cboTopicQ03_NotInList(NewData As String, Response As Integer)
Call AddNewtoList(NewData, Response)
End Sub

or rather I have 30 of them

Does anyone know of an easier way?
I've enclosed a copy of my database in case it helps

Working_pastpapersDB.zip

[RuralGuy]

When I encounter repeating names in a table it usually means there is probably something wrong with the design. I've looked at your db Andy and I'm not really sure what you are trying to achieve. Perhaps a little tutorial would help me.

[andy49]

https://www.accessforums.net/showthread.php?t=65788

I'm planning ahead for next year....

I'd like to record whether pupils master the skills in a topic over time so that I can then assist with their final revision

The practise exam papers they take have 28 questions on different topics

the attached DB is my attempts at recording which topics are being tested in which exam paper.



So I look at q1, its on probability so I store that in my tbltopics and then store it as the topic being examined in Q1 in the tblExam field

Happy to answer more and many thanks for taking a look

[jwhite]

RuralGuy is pointing out that you have repeating groups of fields - your test questions/topics should not be unique columns; rather, they should be unique records. Once you resolve the database design issue, then you can move on to resolving NotInList (http://allenbrowne.com/ser-27-01.html)

[andy49]

Thanks jwhite

Back to drawing board I guess

Any suggestions/advice more than welcome. Design is not my specialism as you can see

[jwhite]

We need to know more about what manual processes you are automating, and the purpose of creating a database for it. Explanation with sample data would be good. The database design you currently have looks incomplete for any kind of process.

[RuralGuy]

I'm thinking one table for TestNumbers and another table for the Topics for each test with a FK to the TestNumber table. Use a Form/SubForm to edit the Topics table with the TestNumber FK as the LinkMaster/ChildField.

[ssanfu]

Got this...

Each paper has about 20 questions covering 1 topic

Don't understand this.......

and each question may be out of anything up to 5 marks

Maybe a starting structure like this:

[andy49]

Thanks ssanfu. The questions are allocated a number of marks depending on their difficulty and length. Short easy questions worth 1. Longer more complex worth up to 7. Totalling 100% of course.

1 question = 1 topic
1 question may be worth 1 point or anything up to 7 points

[ssanfu]

Maybe change the field tblExams.NumOfQuestions to tblExams.TotalNumOfPoints. Then you could calculate the the percentage correct...???

[andy49]

I'm not sure

I have this at the moment

I'd value anyone's thoughts

[ssanfu]

You have tblExamPaper and tblScores in a 1-to-1 relatioinship??? One pupil can have one score and one score goes to one pupil??




Maybe

[andy49]

Ok yes that looks better. Thanks. Now to design a form to enter the specific stuff for each exam.


Sent from my iPhone using Tapatalk