X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Recognition Of Difference Double Click And Single Click, Access 2016    
post Jul 11 2018, 03:28 AM

Posts: 44
Joined: 9-June 18

Hi UtterAccess

Is there any Recognition of difference double click and single click

for the following reason:

I have found this article
a workaround, which utilizes the Form_Timer() event, if you're not already using the timer for something else on that form. Here's a sample:

Option Compare Database
Option Explicit

Private mblnDoubleClicked As Boolean

Private Sub cmdClicks_Click()
Me.TimerInterval = 200 'turn on timer
End Sub

Private Sub cmdClicks_DblClick(Cancel As Integer)
mblnDoubleClicked = True 'set flag
End Sub

Private Sub Form_Timer()
Me.TimerInterval = 0 'turn off timer

If mblnDoubleClicked Then
mblnDoubleClicked = False 'reset flag
MsgBox "Double Clicked"
'run 2-click code...
MsgBox "Single Clicked"
'run 1-click code...
End If
End Sub

But in our case we are using a OnTimer = 1000 in the properties of the form,
in order to update a clock

We have a second form, that does not use ontimer, so I will try there.

But wanted to find out if any other methods exist by members to distinguish in VBA.

We are using the double click to drill down from a crosstab query to a standard form.
And we are now attempting to use the drag/drop method on the same crosstab query to update, when the drop is detected.

Thank you kindly

While the single click
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    18th July 2018 - 02:03 AM