Search results

This is starting to go over my head! I have checked for null values and that is all fine, everything is where it should be. I've added that last bit "> 0", and when I first add the code its fine, but when i go to test it out on the form, it brings up that same message "runtime error 2465" and...

Ok, thanks for the tip about the field names. Will begin that job next time. The code seems to be working at the right time, but comes up with this error now "Microsoft Access cannot find the field "l" referred to in your expression" And then with the debugger opens, this line is...

ok, I seem to be making some progress, and have put the code in to the before update section. However the debugger comes back at me about the spacing in the code. I have: If DCount("[Student ID]", "Classes - Student Lists - Completed", "[Student ID]=" & Me.cboStudent ID & " AND [Class Code]="...

Hey Dcx693, Thanks for the reply. Im pretty new to all this. I think the second option is the go, but I have no idea how to go about it. I have had a look around the board for advice on functions and Dcount, and cant find any. I've got a few questions (!) and the first one is How do I enter...

Hmm, I need some help. I have a table that is keeping student report cards and I need to check if a student Id has already been entered for a class already. The situation is that there are several students per class, and several hundred classes. Each student has a unique ID number and each...