Search results

I did as you said, and I remembered to remove the paramaters. The result was: without subject table; all subjects with subject table; only subject 1 By my way of thinking the result without tblsubjects was accurate. Please excuse me, but I don't quite follow what you are trying to achieve?

Ok.. here is the update, I have created a yes/no field and an afterupdate event: Private Sub chkEnrolled_Click() DoCmd.OpenQuery "qryAppendUnitstoStudentClass" DoCmd.Close acDefault, "qryAppendUnitstoStudentClass" End Sub problem now is it is not finding the studentclassID [NB: I have...

Perhaps I need to tacktle this a new way... I am thinking of creating a tickbox which when selected runs the append query, the tick box would then indicate to me that I have appended the outcomes to the student, thereby completing enrolment. I will play with this idea for now.

Hi I have changed the view to datasheet as you suggested and it works fine with studentid where the number exists. However when I use the next number i.e. for a new record the result is blank. Which again leads me to believe it must have something to do with the form being in new record mode...

Do you think it is because the form is in new record mode?

Yes, I did replace the code, and as you suggested, placed a temporary message after fRunQuery "qryAppendUnitstoStudentClass" and the message appeared without error. which is really really weird

Here is a copy of the db, perhaps it will help. From frmClasses, there is a commandbutton 'Add Students' which opens another form frmAddStudentstoclass which has the commandbutton in question. cheers Tanya

Hi Thank you for your input. I placed the code as you said in module1 and added the code fRunQuery "qryAppendUnitstoStudentClass" and nothing happened. It was like there was no code attached to the commandbutton. Any thoughts? Regards Tanya

I have been fiddling with the append query and have found I could do away with a couple of the tables, here is what I have come up with: INSERT INTO tblCompetency ( StudentClassID, SubjectID, UnitID, ElementID, PerformanceID ) SELECT tblStudentsClasses.StudentClassID, tblClasses.SubjectID...

Hi I have a commandbutton which invokes an append query. The idea is when I add a student to a class the student is allocated a number of units, elements and competencies which they need to become competent in. I could run the append query for the whole class without paramater for...

Congratuations to all the VIP's, your support is greatly appreciated. Regards Tanya

Here is a copy of the db, may help in understanding the problem. thanks in advance

Hi John I've made progress but having a little difficulty with the code. My commandbutton is on the first Tab of frmClasses and I cannot get the code to find the field [classID]. I have tried stLinkCriteria = "[ClassID]=" & Me!frmClasses.Form[ClassID] & stLinkCriteria = "[ClassID]=" &...

Ok, I think I understand now, So I create an append query which uses for its criteria text on a form i.e. [frmAddStudentsClass].Form![StudentClassID] then run that query from a commandbutton. Is this what you are suggesting, or do I need to run the sql for the query in vba?

John I haven't run an update query and new record from a command before. could you offer me some guidance here please. Because my list of students is on a subform and I don't want to see all the fields ie studentclassID & ClassID [I would like to inherit classid and create studentclassid from...

Thank you John, that sounds like a good solution, I've been looking at it from a different angle, at present my students are added by selecting from a dropdown box as you have probably seen from earlier posts. I will play with it and see. thanks again. Tanya

Hi I have thought long and hard about your suggestion and have come up with a query which will append units to a class of students. However I have no idea how to make this happen by default when a student is added to a class? I was thinking along the lines of a list box with multiple selection...

Hi, I've been looking at your problem and scouring the internet for answers and can understand your frustration. Sometimes the easiest solution is the best and therefore I suggest you use the validation list option. At least it will save your sanity :)

Taken on board, thanks.

Hi I have finally solved this problem. You were on the right track! I've simplified the whole idea. Thank you. Regards Tanya