Long Click Event Possible?

[ItsRoland]

I'd like to have code trigger if a user clicks a button for an extended period of time, i.e. they hold left click on a button for ~3 seconds. I've done a bit of research on this and found the "Form.TimerInterval" property, and the "Form_Timer" event, but that just triggers ever X seconds based on what the TimerInterval is set to. Is there a way to use that to accomplish what I'm trying to do? Is it possible to time how long a button has been pressed down for?




From what I found through my searching it seems to be possible, I've just never done anything with timers in access so I'm not sure what the best way to go about it would be.

As always, any help is appreciated!

[Minty]

The only way you could achieve that would be in the Mouse Down event https://msdn.microsoft.com/en-us/vba...or=-2147217396
You would have to save the time it was pressed (in a form level variable) , then in the MouseUp event check the length of time elapsed and if appropriate fire your event.

I personally would probably avoid doing this, as I suspect it will make all other mouse driven events very flakey.
Add another button or a right click menu for "special" actions.

[ItsRoland]

I looked into setting up a right click menu as you suggested, but from what I saw it requires a reference to the Microsoft Office Object Library, which I do not have and cannot get at work. Is there another way of doing this or am I stuck using the mouseDown/Up events?

[Minty]

If you have Access installed you will have that reference library installed as well.
Pretty certain that its a default of any Office install..

[ItsRoland]

The example code I found was using "Dim combo As CommnadBarComboBox", which gives the error "User-defined type not defined". Not sure if that means I don't have the reference I need or not, I've never messed with this kind of thing before.

[Minty]

You don't need that to create a right click menu.
I haven't got the code to hand but it can be achieved without any external reference as far as I can remember.

Have a google for Access shortcut menu's

[Micron]

There is no "long click" type of event for a control itself.
I think a mousedown event on a form will only apply to the form on which the code resides and won't affect any mouse clicks anywhere else. You'd get the system time at the point of the mouse click, loop until you arrive at the new time (start time + specified interval) and at the end of the interval, check if the button is still depressed. This would require diverting to another function (not sub) that returns the mouse button state value. So a lot of code for what seems like a weird goal, and upon every mouse click on the subject control(s), you would not be able to do anything until after the function runs, which is after the loop finishes. Why would you care if I, as a user, held a mouse button down for several seconds, especially if you're going to force user to move off the control to respond to a prompt.

[orange]

Roland,

Can you tell us in business terms (plain English) why you want to do this?

For example, if you had a button and when clicked it invoked some code --what difference exists between a "normal" button click and a long click button you envisage? I'm not seeing the need, but I (and readers) do not know the details of your requirement.