1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
| Private Sub Img_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
Dim Cdb As DAO.Database
Dim RS1 As DAO.Recordset
Dim strSql As String, lText As String, lTextInfo As String
strSql = _
"SELECT R1.* " & _
"FROM R1 " & _
"WHERE Id=" & mT_Reg(5) & ";"
Set oRst = Cdb.OpenRecordset(strSql, dbOpenDynaset)
If Not (oRst.EOF) Then
Do Until oRst.EOF
lText = oRst!Ligne1
oRst.MoveNext
lTextInfo = lTextInfo & lText
Debug.Print "rs1!Info : "; RS1!Info
Debug.Print "rs1!Ligne1 : "; RS1!Ligne1
Loop
End If
With oGdi
.DrawRectangle Gauche, Haut, Droite, Bas, Coufond, RGB(143, 143, 159), , , alfa
.DrawText lTextInfo, TailleText, strPolice, Gauche, Haut, Droite, Bas, , , CouText
.FastRepaint oCtrlImage0
End With
' Etc. ...
End Sub |
Partager