No more double-click code access?

  • Thread starter Thread starter Allen_N
  • Start date Start date
A

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
 
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.
Click to expand...

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

-Tom.
Microsoft Access MVP
 
Thanks, Tom!


Tom van Stiphout said:
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
Click to expand...
 
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)
 
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.
Click to expand...

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.
 
Back
Top