Search results

Yes, it has a master child linkk to another subfrom which is bound to tblYearLevel. Both linked via YearLevelID

Is it possible to change the field fore color at "Form_BeforeDelConfirm" to white color, so the the "#deleted" would be hidden and do not confuse the users ?

When I cancel the deletion, the "#deleted" disappears too. :)

Thank you for the replay. Actually, the "#deleted " appears before delete confirmation and disappear after the delete done, as i delete that filed of the subform form another subfrom that bound to tblYearLevel. So should I worry about ?

Hello everyone, in my database below I got "#deleted"appears in credit field (subform) when I try to delete levelID from tblYearLevel. However, it seems that the delete process done properly, so should I worry about it? if yes, then how to fix. Many thanks.

This a sample of my access database file. Sorry for the bad organizing of the forms.

Sure, 1- My school include 6 levels (level 1 to 6). Each level can divided into A, B,C ..etc depending on the amount of the students at each level. for example, Level1A, Level1B, Level2A, level2B,Level2C...etc. 2- One level spends one academic year to finish. 3- Students can join the school...

Many thanks for the link. May I know what other requirements you want to know please?

Ok,I really appreciate your help. Do you have any valid links or resources to get ride of relationships with multi fields? something like in the captured picture I want know more about it.

I posted my all requirements,and your model helped me a lot. I just want to extend you model to make it work the way I want. Again, I am really new to idea of using relationships with many fields for the same table. Just have a look at my captured picture again and tell how to fix the model...

I browsed the whole database models at the school and student part. No one of fit to my school system.

I just want to make a student to register to the level in separate table added the academic year to that table, then register for the courses that belongs to level registered. So the user. So, the user will have the following data entry forms: 1- LevelCourse form with subform to assign the...

Now I can't get the relationships in the right way. Please see the photo attached. I am getting error "no unique index found for the referenced field of the primary key". That happened when I deleted the relationships between the "StudentCourseLevel" table and MarkTable and re-create it...

Oh! now I noticed that I can't insert into table StudentCourseLevel. I got a warning "you cannot add or change a record because a related records is required in table StudentCourseLevel ", What the wrong I'm doing? please help

Again, it works very nice to me. Could you just help me how to achieve the job I wanted from my previous post ?

The form is based on the students table, then the subform located in it

Attached the revised model It looks very nice to me.

Dear jdraw, I have revised the model and it works very nice to me. However, some issues in the progress appear. Let say, I have a table StdCourseLevel with the following fields: StudentID LevelID YearID CourseID Credit and a subform StdLevelYearSub, having the fields...

Regarding the FailingStuden, your code works perfectly. Many Many Thanks

OK, the students data entry is look like the attached picture I created a form based on the Students table which hold students ID, Name and another information. Then placed an unbound Combo Box with LevelID as row source. A sub-from is also build to show the corresponding courses for the...