The complexity of Controls' Events

[Sun_Force]

As pointed out no control I know of can do both the single and double click.

Wrong.
Lables can and I used them as I explained above. If you accept a label as a control.

I tested it again. seems that you're right. But I swear last night I could double click a label. (maybe it was a dream. Not sure anymore)

But you can use a mouse down instead of the click event.

@MajP you're a genius. Never thought about that. a very clever idea. thanks

 

[Mike Krailo]

Yes he is. I was the one in the recent thread he referred to. In my case it would have been nice to have both double and single click events on one button since the button was part of a calendar. MajP suggested using mouse down event and that solved the problem. It's relatively easy to click or Ctrl-Click a button.

 

[Isaac]

I like the idea. I may use it for the next assignment. If it's OK....
(though we've been strictly asked to use our own ideas....Receiving hints and help to achieve our goals is OK, but copying the whole work is not allowed)

I don't care what anyone does with any of my ideas. It's exclusively your decision.

 

[Mike Krailo]

This entire forum is a plethora of ideas. Give credit where credit is due or required but I cannot imagine getting anything done without using code snippets that just work. If you design for reusability, then those type of modules are useful in many projects, not just one. Try not to hard code data in your programming in favor of variables and functions (reusable code snippets). I believe MajP uses that philosophy.

 

[CJ_London]

DS view gives a huge added value in sorting and filtering without code.

you can sort and filter continuous and single forms without code as well - just right click on a bound control. For me, benefit of DS is you can change column widths/order and also freeze columns

 

[MajP]

If working with DS this is an invaluable resource. There are a lot of features of the DS that are not easily exposed and some are not documented.

You Can Do That with Datasheets? - vb123.com

Everyone who uses datasheets knows they’re powerful, but very few people know all of the things you can do with them. Michael Kaplan pulls out a handful of tricks from the unlocked Access 97 wizards that can help you really … Continue reading →

vb123.com

I did notice that these features now come up in intellisense, but if I remember correctly many of these properties did not previously appear.