No more double-click code access?

[Allen_N]

I am trying to come to grips with the numerous changes in Access 2007. One
of these is that double-clicking a control does not open it's OnClick event
routine, even if the VBA window is open.

Can this functionality be enabled, or is this another irritating security
feature from the people who claim to be providing enhanced productivity every
time they take functionality out of Office?

Thanks!
-- Al

 

[Tom van Stiphout]

On Mon, 3 Nov 2008 17:35:01 -0800, Allen_N

What I use is Office Key > Access Options > Object Designers > Always
use Event Procedures.
Then on a control Right-Click > Build Event, or in the Property Sheet

Events tab > Click on the button next to an event name.

Of course you could write an AutoKeys macro to automate some of this
if you're really so inclined.

-Tom.
Microsoft Access MVP

 

[Allen_N]

Thanks, Tom!

On Mon, 3 Nov 2008 17:35:01 -0800, Allen_N

What I use is Office Key > Access Options > Object Designers > Always
use Event Procedures.
Then on a control Right-Click > Build Event, or in the Property Sheet

Of course you could write an AutoKeys macro to automate some of this
if you're really so inclined.

-Tom.
Microsoft Access MVP

 

[Guest]

You've been using VB6! Double clicking on a control has
never worked in Access, and it always irritates VB programmers.

It's not clear why the Access folks didn't change their
interface to be the same as VB after VB3 was released,
although I note that two single clicks on a control in
Access has a meaning - I can't remember if VB6 has
an action for two single clicks.

(david)

 

[jacksonmacd]

On Mon, 3 Nov 2008 17:35:01 -0800, Allen_N

What I use is Office Key > Access Options > Object Designers > Always
use Event Procedures.

Thanks for the tip. I recall applying a patch in A97 to invoke Always
Use Events Procedures, and missed having that behaviour in A2003. Did
not realize it was a selectable option! It's in the Options >
Forms/Reports tab.