Recent content by Nadia

& it just register the first course from: "WHERE Cid='c1' Or Cid='Ci1' Or Cid='Ci2' Or Cid='Pl1' Or Cid='EIT'"

hello every one, i have a SQL statment, that insert list of courses to Enrollment table (Default courses to new students) from another table .. 'called available_courses the problem is that some courses have more than one section, and i don't know how to select just one of the sections ...

OoOooOops!

Not exactly null, i mean that sometimes a course doesn't have a previous course, the idea is checking in Pre_course table to see if it has a previous course, if it hasn't, then register the course if it has ,we have two options, 1. the student take the previous course and get a mark >= 60,then...

Now he want to check the grade of previous course, so it should be the first one but it still not working (get the message box) and when trying the other one i still have the NULL values problem

and yes i guess so , Everyone's a winner :)

hhhhhhhhhhhhhhhhhhhh hope that my teacher won't come here! he is my lecturer in university, and almost 30 student should do this project but using different applications, and no i don't think that he would sail all the projects ;)

You always find the solution! - i got the same old problem about adding null values! will check the tables to find the reason of that , and hope that it will work well then thanks Vila

i chose a course which it's Previous course is taken, but i get the message box

No, i get red lines in the code

the first one Vila didn't work i get: Compile Error argument not Optional ( @ !Sid) and yes C1 i use it to test the Sql statement and forget to change it, and about comparing two values , isn't right to Dim StrSQL as integer? Now i'll test the other ones ..

Dim StrSQL as string Dim strSQL1 as integer strSQL = "SELECT Pre_crsID from Pre_course where Cid= "C1";" IF IsNull(StrSQL) Or StrSQL = "" Then DoCmd.RunSQL = "insert into enrollment (Crs_id,Ehour , Eday ,room_No,sec_id,instructor_id,sid ,sem_no) select '" & Me!cid &...

Sid.RowSource = "SELECT DISTINCT Student.SID FROM Student INNER JOIN Department ON Student.dept_no = Department.deptno WHERE Department.Head_of_dept='" & Forms!Employee_login!Eid & "'" this one worked :)

i found it :o wasn't able to open Form properties until i select form from properties window .. however, it still not working and asking me to enter department number

i mean load!