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 35 36 37 38 39 40 41 42 43 44 45 46
| Option Compare Database
Option Explicit
Const CTIMER = 10000 ' 10 sec
' ---------------------------------------------------------
' chargement formulaire
' ---------------------------------------------------------
Private Sub Form_Load()
Me.TimerInterval = CTIMER
End Sub
' ---------------------------------------------------------
' Déplacement souris
' ---------------------------------------------------------
' .. dans la zone détail
Private Sub Détail_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
ResetTimer X, Y
End Sub
' .. dans zone formulaire
Private Sub Form_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
ResetTimer X, Y
End Sub
' .. au dessus du contrôle txtTexte1
Private Sub txtTexte1_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
ResetTimer X, Y
End Sub
' ---------------------------------------------------------
' événement timer
' ---------------------------------------------------------
Private Sub Form_Timer()
Me.TimerInterval = 0
Me.txtTexte1 = Me.txtTexte1 & vbCrLf & Now
DoCmd.OpenForm "form2"
End Sub
' ---------------------------------------------------------
' Procédure pour réarmer le timer
' ---------------------------------------------------------
Sub ResetTimer(X As Single, Y As Single)
If Me.TimerInterval <> 0 Then
Me.txtTexte1 = Now & " " & X & " " & Y
Me.TimerInterval = CTIMER
End If
End Sub |
Partager