Search results

Hey Orthodox Dave, I have tried using the codes that you gave me earlier but it gets very complicated because I have 3 columns for cboProject and 2 column for cboInspector. And I have over 60 Projects and Inspectors respectively. Anyway I currently have the following codes.. Private Sub...

Okay I tried debugging everything. Turns out I have to change the Record Set Type from Dynaset to Dynaset (Inconsistent Updates) . It's working now. Thank you :):):)

Thank you for the link! I have run through the checklist but still couldn't find the culprit for this error. Is there any VBA code that can override this? :(

Oh sorry for misunderstanding. I have checked, I could not change the data in the query table too. I have noticed that ever since I added a combo box on the main form, there are errors on the subform. I guess there is something that is not right with the addition of the combo box. Because in...

Wait I have checked under Data -> Allow deletion and addition. It's already set to yes. Still couldn't find why the error msg is not showing up , if there is an error.

I don't understand what you mean by "See if you can enter data directly into that" Where exactly? :confused:

I have a loop subform named sfmLoopMess on a Form named frmMess. Before this, I can change the data from the subform. After a few additions of combobox and stuff outsiude the subform (that I think unrelated to the subform), I can no longer edit what is inside the subform. I attached the...

Thank you Orthodox Dave! I tried the Me.Refresh work perfect when I changed my combo box to table/query. But I might want to change it back to Value list, just to see if your code works. Thanks again. :)

It finally works! I just use CurrentDb.Execute "Delete * FROM tblMessauftrag WHERE lngMessauftragNr one time only. And I also found out that I messed up the table names with another. Silly me.

Thank you. The error is not so problematic. When I select a value in the combobox, nothing happend. I have to select the value in the combobox 2 times for the filter to act upon my subform. It is an undesired error and I want it to be flawless, hence, the value list.

Thank you for your great reply Orthodox Dave. It looks very complicated. But both my combo box is not related directly to each other. They are related by the subform. For example, the fields in the cboProject are[ID, Name of Project] and in Inspectors are [ID, Name of Inspectors]. There is a...

So there is no other way to make cascading combo box without using table/query type? I chose to use the Value List because there always seems to be an error with my form when I use Table/Query row source type for my combo box.

I have two combo box on the main form and both with a Value List for the Row Source Type. The first combo box name is Project and the second one is Inspector. Right now, when I select a project from cboProject, the subform will be filtered only for the selected Project. Same thing goes when I...

Thank you for your reply. I figured maybe I should just write CurrentDb.Execute once only. Not three times. But then I encountered another problem. I just want to delete the selected record on the subform. See photo at #6. With the code below, when clock on the delete button, it deleted the...

Here I attacthed the screenshots of my file. Hopefully you can understand how my data works.

Okay understood. I have checked the tables and relationship. It seems that the record from the subform that I want to delete is the child record. So I assume if deleting it should not cause a problem? And I also found another Delete Button inside a subform of another Form. It uses a different...

Thank you very much for the reply and explaining it very clearly! Where can I find the 'enforce' option? Is it at the relationship table? I think i am going for option 1. But do you know why this suddenly happened? When I first got the database everything works out fine, until I added some...

Hi there. I'm new to programming in VBA. I am currently doing my internship and I am responsible for the programming part in Access-VBA. The programm is already made by the previos intern, so I just need to find the errors and fixed it. I have a form named frmMessauftragsverwaltung and a...

My name is Fara. I am new to Access. I know about the basic stuff on Access but I am not good at programming in VBA, which is my task as an intern. I am from Germany. Nice to meet you all and I hope we can share our knowledge and help each other here. :)