Search results

Thanks so much. You are really a blessing in this group. Be blessed.

@arnelgp kindly assist me to make a form to filter: 1. Years 2. Term 3. Gradedesc 4. Stream I really really really appreciate from the bottom of my heart. Thanks. Be blessed.

Kindly have a look at the attached excel spreadsheet. I believe it is easy to be filtered if years, term, gradedesc, stream are at the title of the report. Kindly look at the adjusted time. Thanks so much

You are really very experienced in databases. Be blessed so much. Your Report works perfectly. I made a slight mistake in that excel spreadsheet. I realized that you cannot filter to show classes and streams. Kindly take the following to be Report titles 1. Years 2. Term 3. Gradedesc 4. Stream...

Thanks so much

@arnelgp kindly please assist me

The time to be autopopulated automatically

@arnelgp thanks so much for your help. I am trying to recreate the Report from teachers schedule to be like the one in this attached excel spreadsheet. It has taken the whole night and the whole day and I am defeated. Kindly assist me. Kindly look at this excel spreadsheet

Thanks

@arnelgp I want to use 1_TeacherSchedule. Is it possible that the moment you select the teacher whose records have not been entered the teacherssubjectroom subform becomes blank because the records for the teacher have not been entered???? Records to be shown when a teacher whose records have...

Ok thanks Ok thanks

@arnelgp when you debug it takes you to: .LinkChildFields = ""

@arnelgp how do you capture the error. If by mistake, the user writes the year manually in 2_TeacherAllSchedule it produces the error: Run-time error '3464' Data type mismatch in criteria expression.

@arnelgp you are doing good work. I really appreciate

Thanks so much

@arnelgp I guess I am not asking too much. Please kindly assist me with vba code for this database such that the moment you select the name of the teacher (1) the Subjects which the teacher teach are automatically shown in the teacherssubjectroom only and (2) the Subjects are shown and the...

Oh I get it. I will change in table property sheet from auto to none. Thanks

Oh ok. How do you remove them yet it was automatically created by access when you enforce referential integrity? I guess there is alot to learn but I am happy I am in the right forum. Thanks for your explanations. I appreciate.

By the way what is the other alternatives to creating forms and subforms or rather subdatasheets?

But it works perfectly for me so I guess I will stick to @arnelgp table structure but thanks anyway