Recent content by Scolton

Thanks i got it working. Sorry for the late response^^

Hello, I have a table which contains the primary key, begin date contract and end date contract. Now i want to get a notification (email) when a contract is almost about to end. How can i set this up? Thanks in advance.

oke i have a table which is linked to Subform1 in the table i have general info like name telephone number email etc etc and then in my second table for subform 2 i have the other info like courses that person follows. In the attachement you can find screenshots from my tables and relations. I...

Hello, i am building a user creation form. I have built it with 3 subforms Subform 1 is voor general information about the user. Subform 2 is some more specific information about the user Subform 3 is more info about the same user. Now when i create a user (record) in subform 1 it gets the...

Hello, I am building a user creation form. i set it up like the screen shot in the first attachement. 3 different tabs. In tab 1 you create the user which then gets a unique key (DocentenID). Table 2 you can input more information about the user (in a different table) i want it to grab the...

Hello, I am building a form to create a user record and at the same time i have some yes/no options which are located in other tables but when i want add a user i cannot select any yes/no options they seem locked? thanks in advance

oke somehow i have figured it out^^ thanks for the help.

completly forget my other "story" i want to create this. Table 1 has all the teachers in it. Table 2 has the study's they teach Table 3 has the subjects they talk about. How can i set this up relationship wise. you can find a screenshot in the attachement. i stil want to achieve the same as...

completly forget my other "story" i want to create this. Table 1 has all the teachers in it. Table 2 has the study's they teach Table 3 has the subjects they talk about. How can i set this up relationship wise. you can find a screenshot in the attachement. i stil want to achieve the same as...

I understand that he would automaticly be related to English and Dutch. But Student A only follows English and i want to see that he is in group 12B and see that he only follows English So actuely i want him to only be related to english in group 12B and not English and Dutch is this possible...

Hmmm i think i didn't explain it correctly. You can see it as this: Table 1 students (includes al students with a unique primary key) and has a one to many relationship with Table 2. Table 2 has Groups in it. Table 3 you can see as a subgroup of Table 2 because it has all the classes in it...

Hello, I wil introduce myself i am a dutch student. At the moment i am working on a database but i ran into a problem that i can't get my head around. Lets say i have 3 tables Table 1 : Has students in it Table 2 : Has their groups Table 3 : Has their classes they follow. Now i want i want to...