Search results

Hello. I have adapted the code to a class module, as I need this for a more complex module. Now, in this case that I am attaching, I have added a second subform. I can tell if it goes from one subform to another using a MsgBox and the ActiveControl property. However, I need to know that the...

Ok, thanks. Solved.

A msgbox that says you have moved to..., each way. And it doesn't matter the control I am not able to suppose that questions to answer in my first post. Sorry

Ok. Sorry. I want a msgbpx when I move from a main form control to another control of the subform, and another msgbox from a control of the subform to another control of the main form. There are no more events because I don't know which one I have to use. Thanks.

Hello. I would like to detect using VBA when I change a control: From subform to main form. From main form to subform. I have tried events from one and the other and I can't find the key. I have made this small example, to which I ask you not to try to understand the logic of the name of...

Thanks

Solved. Here's the database with the solution that Josef P. gave to me.

I'm going to remove the previous database because I see that it is too complex for something so simple. I have made a simpler example and in English. The question, which is also in the AfterUpdate event of the Date field of the only form, is as follows: How can I achieve through VBA that...

The scheme would be like this. Be careful that in a year there may be some type of subsidy that is paid more than once.

REFORMULATED QUESTION: see my post below. I put it in a simpler way and with a very simple database.

Thank you very much, it is an option, but I wanted to do it through the class module. However, thanks to your example, I have understood that the ribbon displayed is that of the form that is active, it does not matter if it is a main form or a subform. Therefore, I don't have to put...

Sorry

Ok, I have already fixed USysRibbons table and I don't get any errors. I am attaching the database so you can see for yourself. I thank you very much for having the detail to inform me of those errors in the ribbons that I have created. Now, this doesn't solve the problem I came here for: I'm...

I have solved two of the three problems with the ribbon, but I have no idea about the third one, because I don't know where the problem is. Regarding the problem I raised at the beginning, it still does not work, as it is as if the main form ribbon was not updated.

I attach an example with two forms: one with a subform (where the problem is), and another without a subform so you can see the behavior it should have. You also have a small video commenting on the problem.

Hello. I have a form with a subform. I am trying to achieve, through a class module, that the ribbon of the main form changes when entering a textbox of the subform. I have tried Form.Parent.RibbonName = "RichText", but it gives me an error, and I don't know how else I can put it. Thank...

It is fixed. She was putting the subtables after the main tables. Consequence? Well, since there were records that relate both tables, it only eliminated the data from the subtable. This is why I saw the form filled out and also explains why I had to do it twice: the first time I deleted the...

Fails. It says that you have to delete the related data to get the data from the table.

I also give you a video. 1. First, I show you a form that contains data. 2. I exit the form and open the form where I have the button. 3. I have this button in a form that I have made that is accessed previously by entering a password that only I know. 4. I delete the data. 5. I go back to the...

Look, this is the tweaked code. As you can see, I have only added the tables that I am interested in, eliminating all the records. It is a database to generate invoices and estimates, to which I have example data entered. Therefore, if I want to give it to someone, I have to delete the data. And...