Search results

  1. T

    Menu buttons of a custom menu are not working

    Hi everybody, The following problem occurred: I build two database for gathering information from two sectors of our organization. A third database is used as a management tool to open the most important reports of both databases. By pressing on a button in the third database, code below opens...
  2. T

    Converting rows into columns under certain conditions (agenda like)

    I made a temporary table for the second table, TempAppointments: Person-Id | Appointment_1 | Appointment_2 | Appointment_3 | Appointment_4 | Appointment_5 And by using a VBA function, the table will be emptied and after filled with the new information: Public Function order...
  3. T

    Converting rows into columns under certain conditions (agenda like)

    I see what you mean. I would like to clarify my approach. Not all the people in the database are used in the query for the overview. It will only be used for a limited and selected number of people. Also the appointments are limited to certain appointments. Not all the appointments are put in...
  4. T

    Converting rows into columns under certain conditions (agenda like)

    I would like to print the overview of the data when it's in the desired order. It's mainly to have a quick view of the upcoming appointments. You call the data not sequal and fragmented. Sorry for not understanding (I'm Dutch, so there is some of this 'lost in translation':o). The Person-Id...
  5. T

    Converting rows into columns under certain conditions (agenda like)

    Hi everbody, As a rookie to Access I browsed many forums in search for an answer to my problem. I've got a relationship based ageda/calender for multiple people (100+). The information of those people is ordened in one table and their appointments in another. The appointments are already...
Top Bottom