Search results

Thank you so much, this actually worked :) Gonna test some more to see if everything is ok. Again, thank you :) Ps. If you ever need help with Photoshop, I'm here to help you :p

Exactly. So when I add a new entry in table A, C should also be cleared so I can add new data. But that's not the case right now. Ok maybe a stupid question but how do I do this? :o Thanks for the reply btw.

Hi, I created 3 tables, table A,B and C. Table A has a one to many relation with B and works. Table B has a one to many relation with C but this is giving me problems. It's like Access can't see the relation between B and C. When I create an entry in table A, table B sees this but C doesn't. I...

Yesss :) Thank you so much for your help :o

Thank you so much B L, I really appreciate your help. There's only one problem though. When I close the form and reopen it, the field is enabled again. I tried to put the same code on before update but that didn't help.

Hi there. I didn't want to create a new topic so I'm asking it here (hope that's ok). I'm trying to disable a field with a checkbox, with the following code: Private Sub Actief_AfterUpdate() If Actief = "Yes" Then klnr.Enabled = True Else klnr.Enabled = False End If End SubI can disable the...

Thank you :) Works now.

I see, thanks for the clarification :) I changed the code like this Me.BegindatumHH.Visible = (Me.invoervak92 In("CIZ")) "BegindatumHH" is the textfield name and "invoervak92" is the combo box name. When I paste this code in the after update field of the combo box, I get an error saying that...

First of al my apologies if this has been asked before but I couldn't find any solution for this problem. I have a form with a listbox with multiple items (Let's say A,B,C,D). When I choose A or B, I want to show a field below the listbox, but if I choose C or D, then the field should not be...

Thank you dkinley :) I fixed the problem by removing room mates FK from tbl customers and adding a customers FK in tbl room mates. I have a lot to learn :o

I cleared both tables just to be sure that that wasn't causing the problem. PK of of tbl room mates is set to autonumber and the FK room mates in tbl customers is set to number (long integer). I uploaded the database, I would appreciate it if someone could take a look at it. Here's the file...

Thank you for the reply. "Klanten" means customers and "Huisgenoten" means room mates. Changing the name doesn't help unfortunately. Table customers has one PK and 4 FK. Creating the fifth FK for room mates causes the problem. I also tried the same name for the PK and the FK in both tables with...

Hello I'm facing a problem with Access which I just can't seem to solve. I'm trying to create a one to many relation between the tables "Klanten" and "Huisgenoten" but Access only allows me to create such a relation between "Huisgenoten" and "Klanten". See the attachment. So this is what I'm...