Search results

  1. A

    Crosstab query in form?

    Thanks for the reply dearGaP42 Even if I add this field in the display table, what will the combo box depend on? The query will remain displayed in the form for a long time because the other materials, I mean stationery materials, will not disappear. I will have to use the horizontal scroll bar...
  2. A

    Thank you, my friend.KitaYama🌷🌹

    Thank you, my friend.KitaYama🌷🌹
  3. A

    Crosstab query in form?

    Thank you, my friend.KitaYama I will add a teachers name field in the query and apply the same concept to the filter combo box. Thanks for helping me. If I need help, will you help me? I will be grateful to you. Suppose I want to copy the query QryInput_Crosstab to create another list similar...
  4. A

    Crosstab query in form?

    This is amazing . Thank you KitaYama This is what I really aspire to. Thank you again. Nice work. When you clear the contents of the filter's combo box and click the Enter button, all the chapters reappear. There is no need to close and open the form again. Thank you dear.
  5. A

    Crosstab query in form?

    Thank you, dear,LarryE for your help. But this is not what I want. What I want is when I select the class the combo box does a filter for the crosstab query. See my comment in #20 For example, during the year I will provide the class (A1) with stationery every week or two. This class will...
  6. A

    Crosstab query in form?

  7. A

    Crosstab query in form?

    I added it to the class table. You have sent the database file #22
  8. A

    Crosstab query in form?

    Yes exactly(y):)
  9. A

    Crosstab query in form?

    Yes, thank you, dear DHookom I would be grateful to you. This is the database. The teacher field has been added to the class table
  10. A

    Crosstab query in form?

    Hello dear DHookom no . I don't want to choose multiple halls. What I want is to select one hall so that only this hall appears for me in the form and the other halls disappear. To avoid confusion in auditing.
  11. A

    Crosstab query in form?

    Thank you dear: Yes, each class has multiple halls, but each hall has a responsible teacher who is in charge of these supplies. Meaning, we say the class (ِA) Teacher George is in charge of the hall (A1) Teacher Miller is in charge of the hall (A2) But they all return to the class (A) basically...
  12. A

    Crosstab query in form?

    I have attached an example database for you. When I choose the crosstab query from the first drop-down list. Through the second combo box, can I create a filter for the sfrmQuery subform?
  13. A

    Crosstab query in form?

    Approximately 17 classrooms, for example, the A classroom contains 4 halls
  14. A

    Crosstab query in form?

    Thank you DHookom Is it possible to add a combo box that creates a filter to the classroom rooms?
  15. A

    Crosstab query in form?

    Thank you very much my dears. I will edit the examples, and if you need help, you can certainly help me. Isn't it?:)
  16. A

    Crosstab query in form?

    Hello everyone What I want to do is convert this table from Excel to Access. And make a cross-tab query. Is there any help? Thank you very much
  17. A

    Crosstab query in form?

    Hello guys How to display a crosstab query on the form? If there is an example, I would be grateful to you. Thanks I have three tables, each table contains sections. There is stationery such as pens, papers, and other materials distributed among these departments. What I want is to create a...
  18. A

    Search through textbox

    thank you MarkK dear It works fine, but why did you put the event in on Private Sub txtSearch_Change() ? Private Sub txtSearch_Change() With qdfSearch .Parameters(0) = "*" & Me.txtSearch.Text & "*" Set Me.Recordset = .OpenRecordset End With End Sub
  19. A

    Search through textbox

    This is database file.
  20. A

    Search through textbox

    Thank you for replying Nothing happens. Yes, it is a query based on a table
Back
Top Bottom