Depuis j'ai avancé un peu. j'ai modifé mon tableau.
les heures en lignes et les jours en colonnes
voici la requete. Je pense qu'il y a plus simple mais je n'ai pas trouvé.
<%Rs.Open "Select heurerdv, " & _
"iif(sum(dt1)=1,'#00FF00','#FFFFFF') as affich1," & _
"iif(sum(dt2)=1,'#00FF00','#FFFFFF') as affich2," & _
"iif(sum(dt3)=1,'#00FF00','#FFFFFF') as affich3," & _
"iif(sum(dt4)=1,'#00FF00','#FFFFFF') as affich4," & _
"iif(sum(dt5)=1,'#00FF00','#FFFFFF') as affich5," & _
"iif(sum(dt6)=1,'#00FF00','#FFFFFF') as affich6," & _
"iif(sum(dt7)=1,'#00FF00','#FFFFFF') as affich7," & _
"iif(sum(dt8)=1,'#00FF00','#FFFFFF') as affich8," & _
"iif(sum(dt9)=1,'#00FF00','#FFFFFF') as affich9," & _
"iif(sum(dt10)=1,'#00FF00','#FFFFFF') as affich10," & _
"iif(sum(dt11)=1,'#00FF00','#FFFFFF') as affich11," & _
"iif(sum(dt12)=1,'#00FF00','#FFFFFF') as affich12," & _
"iif(sum(dt13)=1,'#00FF00','#FFFFFF') as affich13," & _
"iif(sum(dt14)=1,'#00FF00','#FFFFFF') as affich14," & _
"iif(sum(dt15)=1,'#00FF00','#FFFFFF') as affich15," & _
"iif(sum(dt16)=1,'#00FF00','#FFFFFF') as affich16," & _
"iif(sum(dt17)=1,'#00FF00','#FFFFFF') as affich17," & _
"iif(sum(dt18)=1,'#00FF00','#FFFFFF') as affich18," & _
"iif(sum(dt19)=1,'#00FF00','#FFFFFF') as affich19," & _
"iif(sum(dt20)=1,'#00FF00','#FFFFFF') as affich20," & _
"iif(sum(dt21)=1,'#00FF00','#FFFFFF') as affich21," & _
"iif(sum(dt22)=1,'#00FF00','#FFFFFF') as affich22," & _
"iif(sum(dt23)=1,'#00FF00','#FFFFFF') as affich23," & _
"iif(sum(dt24)=1,'#00FF00','#FFFFFF') as affich24," & _
"iif(sum(dt25)=1,'#00FF00','#FFFFFF') as affich25," & _
"iif(sum(dt26)=1,'#00FF00','#FFFFFF') as affich26," & _
"iif(sum(dt27)=1,'#00FF00','#FFFFFF') as affich27," & _
"iif(sum(dt28)=1,'#00FF00','#FFFFFF') as affich28," & _
"iif(sum(dt29)=1,'#00FF00','#FFFFFF') as affich29," & _
"iif(sum(dt30)=1,'#00FF00','#FFFFFF') as affich30," & _
"iif(sum(dt31)=1,'#00FF00','#FFFFFF') as affich31 " & _
"from planning1 where monthrdv="&affichmonth&" and yearrdv="&affichyear&" group by heurerdv",conn
planning1 = une requete access qui regroupe par heure et qui remène 1 si un nom apparait dans le jour de chaque mois. "vous suivez....
ceci me fait apparaitre une couleur dans un tableau.
Je souhaiterais faire apparaitre des infos bulles quand on passe sur une cellule d'un rendez vous qu'il me fasse apparaitre le nom.
pouvez vous m'aider ?
Onha