I am trying to build a database using base that records student grades. I am trying to build a form that makes it easier to enter a bunch of grades for various students on the same subject and lesson. Each grade record records the student, the subject and the lesson number as well as the “weight” of the grade and of course the grade itself.
My Question is I want it to cycle thru the students and put the subject and lesson and weight in and I only need to enter the grade. I realize I can use a macro I just have not quite gotten it figured out. I thought I would ask advice before I went to far.
Hello,
Although not exactly what you describe, take a look at Sample #3 in the answer in this post → Using SQL cursor and loop in LO base macro
It does use a couple of short macros and seems to be a good starting point.
Thanks! I am taking a look at it Like you say it is not exactly what I described but I think It gives me a good start.