Recent content by arsh

In my database I have filter form with 3 combos.when I press ok button on form it shows all records in a query (on the fly).But it doesnt show empty records,so I added strOffice = " Like '*' OR 'Is Null' " but it doesnt work. Please help and thanks in advance. Private Sub cmdOK_Click() '...

I have a form with two combo boxes.ComboTeachers(TeacherID,TeacerName) and ComboStudents(StudentID,StudentName).ComboStudents is filtred by ComboTeachers and shows students of the teacher which is selected in ComboTeacher.When I click a student in a combo by after update event opens a query that...

I have a database with 3 tables > 1st table "Departements"(departemenetcode-autonumber,departementname) > 2nd table "Teachrs"(teachercode-autonumber,teachername) > 3rd table "Students"(studentcode-autonumber,studentname and other information for student) > In "Teachers" table I have combo based...

I have a database with 3 tables > 1st table "Departements"(departemenetcode-autonumber,departementname) > 2nd table "Teachrs"(teachercode-autonumber,teachername) > 3rd table "Students"(studentcode-autonumber,studentname and other information for student) > In "Teachers" table I have combo based...

Maybe another way I have a form with a combo box "Students"(StudentID,StudentName from tblStudents),a command button which opens a query that shows Student information from tblStudents.I want the query to show the information of Student which is selected in combo box. How can I do it. Thanks in...

I do it and see "all" in my combo box but when I click query shows nothing,I think that I have to add smth. to on click event of combo box

I have a Students combo box(stedentID,studentname) that is limited by Teachers combo box(theacherID,theachername).When I click a student in a Students combo box (whith on click event) opens a query that is filtred by a selection in Students combo box.I want to have "all" in Students combo box...