No more double-click code access?

4 Nov 2008 1:35 AM

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

4 Nov 2008 3:52 AM

Tom van Stiphout

On Mon, 3 Nov 2008 17:35:01 -0800, Allen_N
<All***@discussions.microsoft.com> wrote:

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

Show quoteHide quote

>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

4 Nov 2008 5:24 AM

Allen_N

Thanks, Tom!

Show quoteHide quote

"Tom van Stiphout" wrote:

> On Mon, 3 Nov 2008 17:35:01 -0800, Allen_N
> <All***@discussions.microsoft.com> wrote:
>
> 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
>
>
> >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
>

4 Nov 2008 1:28 PM

jacksonmacd

On Mon, 03 Nov 2008 20:52:19 -0700, Tom van Stiphout
<tom7744.no.spam@cox.net> wrote:

>On Mon, 3 Nov 2008 17:35:01 -0800, Allen_N
><All***@discussions.microsoft.com> wrote:
>
>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.

>Then on a control Right-Click > Build Event, or in the Property Sheet
>> Events tab > Click on the button next to an event name.
>

--
jackmacMACdon***@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

4 Nov 2008 12:50 PM

david

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)

Show quoteHide quote

"Allen_N" <All***@discussions.microsoft.com> wrote in message
news:5B87C78C-F6B0-49FA-BFBB-F384C221D37D@microsoft.com...
> 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
>