Search results

  1. Z

    Delete a grouping in an access report

    i got it this way: Reports("ReportName").GroupLevel(0).ControlSource = "Año" Reports("ReportName").GroupLevel(1).ControlSource = "Estado" Reports("ReportName").EncabezadoMes.Visible = False you can check this article...
  2. Z

    Delete a grouping in an access report

    Hello, I have a report that I have structured as follows: I would like to remove the grouping "Mes1" using VBA. I have tried this code but it doesn't work: Me.Section(0).Visible = False Does anyone have any idea how I can get it? I could create another report, and have one for the annual...
  3. Z

    LikeNot in multiple criteria in Dcount

    Solved. Thanks a lot
  4. Z

    LikeNot in multiple criteria in Dcount

    No, keep falling. Thanks
  5. Z

    LikeNot in multiple criteria in Dcount

    No, keep failing
  6. Z

    LikeNot in multiple criteria in Dcount

    Hi. I am trying to make this formula work in an Access report, but it gives me an error. Could you tell me where the fault is? I know it is from [PorQueAñadoEsteLibro]. =DCont("*";"[TLibros]";"[Comprado]=" & Verdadero & " And " & "[Estado]=" & 3 & " And " & "[Libreria]=" & 2 & " And " &...
  7. Z

    It does not relate a form to me with its subform

    It works now. I was calling CodigoTicket to the field that was not. Thank you very much for trying to understand, despite the language barrier. A greeting.
  8. Z

    It does not relate a form to me with its subform

    Hello What I'm trying to achieve is to save those records you're adding when moving from one record to another of the main form. If you go to the table F10TPVSubtabla, you will see that they are saved without CodeTicket, which is what links the main form with the subform. If I told you to...
  9. Z

    It does not relate a form to me with its subform

    Well, I think we're going to leave it here. Thank you very much anyway for the interest shown in helping me. I hope that on another occasion if you can help me. A greeting.
  10. Z

    It does not relate a form to me with its subform

    Thank you. I believe that I have answered everything I have been asked. If I'm missing something, tell me, because the same thing I did not see the question
  11. Z

    It does not relate a form to me with its subform

    There is not a new version of the database. What I published at the beginning is what I'm working with. In principle, yes. In fact, I attached the base with a single record. If you try to do what you see in the video, you should give the error. You can see it more clearly if you add the...
  12. Z

    It does not relate a form to me with its subform

    I have tried to delete the current subform, and add a new one using the Access wizard, and it does work. This confirms to me that it is a problem of the origin query of the subform. There is something wrong in that query that causes records not to be saved. I have tried to add the ID in the...
  13. Z

    It does not relate a form to me with its subform

    That's what I do. So, I copy the translate again: The problem is in the design of the subform's source table. I'm trying to create a new subform using the wizard, and it works. However, when I put SQL through the table it should be, it stops working. I'm sorr'y for the quality of the video...
  14. Z

    It does not relate a form to me with its subform

    The problem is in the design of the subform's source table. I'm trying to create a new subform using the wizard, and it works. However, when I put SQL through the table it should be, it stops working. I'm sorr'y for the quality of the video. Then, problem of the majP module is not. That I have...
  15. Z

    It does not relate a form to me with its subform

    I have recorded a video where I explain how to see the failure. Also tell you that I do not understand the primary keys. Could you attach a screenshot of where they are missing? The data base is redoing it, and now I just realized the failure. Thanks, and a hello...
  16. Z

    It does not relate a form to me with its subform

    If you try to add new records in the subform, they are not saved when you move from one record to another. I assumed it was because of the ticket code, that it is not copied to the subform, but I do not know why. I already know that the main / sub linkage is fine. Do you have this clarification?
  17. Z

    It does not relate a form to me with its subform

    Well, as I mention in the title, I do not know why in a form that I have with a subform, it does not go well with the code because it is linked to the subform, when it should be done automatically. The problem here is that it does not save the new records that I enter in the subform. Could...
  18. Z

    Copy the background color to the hover color

    That's what I do. I create a new blank database and import all objects into that. I didn't explay well. Sorry. I do it because my database is corrupt, but I doesn't work
  19. Z

    Copy the background color to the hover color

    Hello thank you very much. Now it works. I was putting it inside the if, and of course, if the UseTheme was already in Yes, I did not see the effect. There has been a translation error. What I wanted to say is that, when I import the database into a new one, Access changes the UseTheme, and...
  20. Z

    Copy the background color to the hover color

    Hi. Thank you. However, it does not work. Look, although it is in Spanish, but by position it can be useful to know what is to be changed. They are the two that I have inside a box, for the one that is higher up.
Top Bottom