Advertisement

05.29.2008 at 11:20AM PDT, ID: 23442409
[x]
Attachment Details

I need to highlight in succession every second the values in a listbox whilst mousedown over a label, and stop scrolling on the mouseup event

Asked by quentinA in Access Coding/Macros, Access Forms, VB Objects

Tags: VBA, Microsoft access

Programming an interface in Microsoft access. Using vba. Windows vista.
Start Free Trial 
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:

Option Compare Database
Option Explicit
Dim strMouseValue As String
Dim intTimerValue As Integer
 
Private Sub Form_Open(Cancel As Integer)
    intTimerValue = 0
End Sub
 
Private Sub Form_Timer()
    If intTimerValue > 0 Then
        Debug.Print "check " & intTimerValue
        intTimerValue = intTimerValue + 1
    End If
End Sub
 
Private Sub lblTimer_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
    Debug.Print "down"
    intTimerValue = 1
    strMouseValue = "down"
    Me.lblMousevalue.Caption = strMouseValue
    Form_Timer
   
End Sub
 
 
Private Sub CheckMouse()
 
If strMouseValue = "down" Then
    DoEvents
    Me.lblTimer.Caption = intTimerValue
ElseIf strMouseValue = "up" Then
'    intTimerValue = 0
    Me.lblTimer.Caption = intTimerValue
Else
 
 
End If
 
 
 
End Sub
[+][-]05.29.2008 at 12:05PM PDT, ID: 21672311

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.29.2008 at 12:24PM PDT, ID: 21672477

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.29.2008 at 12:39PM PDT, ID: 21672628

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.29.2008 at 01:13PM PDT, ID: 21672920

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.29.2008 at 01:53PM PDT, ID: 21673190

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.29.2008 at 02:09PM PDT, ID: 21673296

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.12.2008 at 01:34PM PDT, ID: 21773459

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.12.2008 at 02:14PM PDT, ID: 21773778

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.12.2008 at 02:47PM PDT, ID: 21773996

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.12.2008 at 05:15PM PDT, ID: 21774716

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Access Coding/Macros, Access Forms, VB Objects
Tags: VBA, Microsoft access
Sign Up Now!
Solution Provided By: harfang
Participating Experts: 4
Solution Grade: B
 
 
[+][-]06.13.2008 at 05:27AM PDT, ID: 21778035

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.13.2008 at 06:38AM PDT, ID: 21778641

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628