[AccessD] moving focus off the tab page

John:

Why can't you use the _Open event of the form to se the focus to the desired
control?

Rocky

----- Original Message ----- 
From: "Colby, John" <JColby at dispec.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Monday, July 19, 2004 9:39 AM
Subject: RE: [AccessD] moving focus off the tab page


> LOL.  I think you misunderstood the question.
>
> When a tabbed form opens, the tab control tends to have the focus, usually
> with the tab0 page of the tab control.
>
> I want to place the control into the first control on the selected tab
that
> can validly recieve the focus.  This means:
>
> The control with the Lowest Tabindex that has TabStop = true that is
Enabled
> that is Visible.
>
> IF I used Sendkeys I could just send a tab key which would cause Access to
> tab the cursor into the first valid control.
>
> Since I don't use Sendkeys, I need another way to do this.
>
> Somewhere in the guts of Access (page control) there is a collection of
> items that may (or are) be in the tab order.  Unfortunately it doesn't
> appear to be exposed for us to use.
>
> I have built a pair of functions to find the first control that can
receive
> the focus.  It involves iterating the collection of all controls, testing
> each control to see if it has a TabStop property, then if it is enabled,
> then if it is visible.  If all these things are true, then this control
MAY
> be the first in the tab order.  Now each such control is tested against
> every other such control to find the one with the lowest TabIndex
property.
>
> It works, and on my machine takes about 16ms to run on a fairly complex
> form.
>
> It just seems that somewhere built in to Access I should be able to ask
the
> object with a controls collection which control in the collection is the
> "first valid control in the tab order", i.e. which control can ACTUALLY
> RECEIVE the focus using the tab key.
>
> JWC
>
> -----Original Message-----
> From: Mike & Doris Manning [mailto:mikedorism at adelphia.net]
> Sent: Monday, July 19, 2004 12:12 PM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] moving focus off the tab page
>
>
> FirstControl is the control you want to get the focus...
>
> Doris Manning
> Database Administrator
> Hargrove Inc.
> www.hargroveinc.com
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Colby, John
> Sent: Monday, July 19, 2004 11:02 AM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] moving focus off the tab page
>
>
> What is FirstControl a property or method of?
>
> JWC
>
> -----Original Message-----
> From: Mike & Doris Manning [mailto:mikedorism at adelphia.net]
> Sent: Monday, July 19, 2004 10:42 AM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] moving focus off the tab page
>
>
> Firstcontrol.SetFocus
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Colby, John
> Sent: Monday, July 19, 2004 10:30 AM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] moving focus off the tab page
>
>
> I need to force the focus off of the tab page into the first control in
the
> tab order.
>
> I do not use SendKeys.
>
> Is there a non SendKeys answer?
>
> John W. Colby
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>