Recent content by yvautrin

All Good! I just copied and paste the combobox from the Form, and it works like a Charm! A Trillion thanks for your help! (y) Now, time for some cosmetic work!

Just did it, but now that the lookup is gone from the Lesson_Plan table, I still end up with the "Teaching_Materials_Codes".... note the text.....:(

Thanks a lot!

when i ad a combobox in the report, it ends up empty.....

I can't get the way to do it... Now, I just managed to achieve displaying the "Text" instead of the code, but the report generate one page for each "teaching material" instead of having the multiple values together....

Thanks all for your advice, I start to understand the problem! Now, I removed the Lookup from the original table, added the "Materials_type" table in the query, with the appropriate relationship! It works perfectly when I have a single item, but I am stuck when I have multiple values, and my VBA...

Here is the SQL code for the query I use for the report! SELECT Lesson_PLans.*, Calendar.School_Year, Calendar.Week_Number, Calendar.Start_Date, Calendar.End_Date, Calendar.Term, Calendar.School_Days, Calendar.Status, Syllabus.Subject_reference, Syllabus.Chapter_Name, Syllabus.Topic_Category...

Good morning All ! I am trying to setup a MS Access database (MS Access 2019) to facilitate lesson plans creation for my school. So far, everything is working fine (Tables, Form, Query), but when I generate the report, based on the query, I have three textbox (Teaching_Materials, Homework_type...

Hello everyone, French CS and ICT teacher living in Sharm el Sheikh, Egypt. Hope to get some valuable help from the community, and share my experience and (little) knowledge with the community!