UtterAccess.com
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    
 
   
AccessQuery
post Jul 11 2018, 03:28 AM
Post#1



Posts: 50
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
https://www.tek-tips.com/viewthread.cfm?qid=990847
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...
Else
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.
http://www.vb123.com.au/201202_ds_drag.htm

Thank you kindly

While the single click
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    22nd July 2018 - 06:00 AM