Search results

  1. zelarra821

    Solved Form with multiple list boxes

    Yes of course. There is no confidential data, only invented data to test. The problem is that it is in Spanish.
  2. zelarra821

    Solved Form with multiple list boxes

    The structure is clear to me: a table with the main data of the clinical record and annexed tables with the options of the fields that require it. This is the relationship of fields that I have created in the main table. I also add if I have created an attached table (generally, if it says Id...
  3. zelarra821

    Solved Form with multiple list boxes

    The example has not been very successful. I give you the case of the barking, which does not appear in the image. For that I have two or three options, but another reason may be repeated in the query that needs to be recorded. The reason for having the possibility of adding is to categorize...
  4. zelarra821

    Solved Form with multiple list boxes

    Hello people. I ask for your help. I am creating a database to make clinical records for patients (dogs and cats) with behavioral problems. I am going to try to explain with examples and everything as much as I can and can imagine right now. So, if something is not clear, or if I overlook any...
  5. zelarra821

    Solved Detect the change of a control from the main form to the subform, and vice versa

    Entonces, además de añadir la línea que tú propones, debería cambiar el tabindex del subformulario en el formulario de muestra a cualquier otro valor entiendo, ¿verdad? Mil gracias.
  6. zelarra821

    Solved Detect the change of a control from the main form to the subform, and vice versa

    Hola, Edgar. Te he grabado un vídeo explicando lo que quiero conseguir, pues veo que con palabras no lo logro. Espero tu respuesta. Muchas gracias.
  7. zelarra821

    Solved Detect the change of a control from the main form to the subform, and vice versa

    ¿Podrías echarle un vistazo a ver si tú eres capaz de lograr que funcione el procedimiento? Básicamente, debe hacer referencia al campo del subformulario desde el formulario principal, pero no sé hacerlo. Muchas gracias.
  8. zelarra821

    Solved Detect the change of a control from the main form to the subform, and vice versa

    Hola, Edgar. Gracias por contestar. El problema no es que no detecte el hacer click en el header o en el Detail, sino que, al hacer click en esas secciones, debe mandar el foco del campo del subform con texto enriquecido a uno que no tenga texto enriquecido dentro del propio Subform. Por eso...
  9. zelarra821

    Solved Detect the change of a control from the main form to the subform, and vice versa

    Luego lo veo. Ahora estoy en el trabajo. Muchas gracias.
  10. zelarra821

    Solved Detect the change of a control from the main form to the subform, and vice versa

    Hola, Edgar. Lo único que se me ocurre es añadir un parámetro opcional en Inicializar para poner el subform, de tal forma que pueda añadir el evento al salir, y quitar el sub para situar el foco. He probado a añadir un encabezado en los dos subformularios que no funcionaba. También he...
  11. zelarra821

    Solved Detect the change of a control from the main form to the subform, and vice versa

    I have made the proposed changes: differentiate header from detail and correct the error. With those corrections, it now works for me in a form when I am in the text box with rich text and click on the detail of one of the forms, but not in the other, and I don't know why. Thank you so much.
  12. zelarra821

    Solved Detect the change of a control from the main form to the subform, and vice versa

    Hello. I have looked at what you have proposed. For that, I prefer how I had it before, and that is that I add an optional parameter to the function that starts the class module to put the textbox that interests me. This way, I can add as many as I want more easily and in the form in question...
  13. zelarra821

    Solved Detect the change of a control from the main form to the subform, and vice versa

    Edgar, what if I wanted to add the two events (Enter and Exit) to more than one textbox with rich text? Thank you so much.
  14. zelarra821

    Solved Detect the change of a control from the main form to the subform, and vice versa

    Hello. Thank you so much Joseph and Edgar. I have reviewed the behavior of what was proposed in post number 15, and what I have published does the same, but in a simpler way. Furthermore, I have corrected and added what Edgar proposed. My idea is to create a class module that does the...
  15. zelarra821

    Solved Detect the change of a control from the main form to the subform, and vice versa

    I had thought about adding to that loop that it only adds the events in which the rich text is active. My goal was what I said before, but I wanted to achieve it through a class module. I know that I have things to learn, that's why I am open to other proposals that go along the path by which...
  16. zelarra821

    Solved Detect the change of a control from the main form to the subform, and vice versa

    Retouching the code of the class module that I had in my databases with what is proposed here, it would look like this: Option Compare Database Option Explicit Private WithEvents mForm As Form Private WithEvents mTextbox As Access.TextBox Private WithEvents mHeader As Access.Section Private...
  17. zelarra821

    Solved Detect the change of a control from the main form to the subform, and vice versa

    Edgar, I stick with your example because of the simplicity of the code. I have a question. Is there a way to integrate the getFormAndControl function into the class module itself? I'm trying to get it to work with the On Click and On Exit Textbox event instead of using that function, but I...
  18. zelarra821

    Solved Detect the change of a control from the main form to the subform, and vice versa

    Hello. Thanks for answering. I wanted to show a summarized example of what I want to do, because if I show you the entire code, it is more than likely that you will not understand what I want to do. My goal is to activate and deactivate the scroll bars and change the ribbon depending on...
Back
Top Bottom