Access tab control and Ctrl-Tab

[Kenny-Z]

(Repost from microsoft.public.access.gettingstarted, Sunday, August
03)

I use and Access 2000 tab control with tab style 'none', command
buttons and VBA for a wizard. The problem is that Ctrl-Tab will change
the tab control value (page) when it (or child control) has focus. Any
suggestions?

thanks,

kz

 

[Joe Fallon]

I use the same style for one of my apps.
I have to confess I never noticed that behavior.

I took a quick look at it and noticed:
1. When I click on the first button and then Ctrl-Tab the focus moves from
button to button but the page does not change. (This is good.)

2. After the LAST button, Ctrl-Tab moves focus to the Tab Contro itself (I
think - didn't really verify.)
But from that point on, Ctrl-Tab caused the screens to change just as if the
user clicked the buttons, but the buttons were all "wrong" for the current
screen. (This is very bad.)

3. The Tab change event fires when you Ctrl-Tab past the last button.
Aha! We can intercept the event and fix things!

Private Sub TabCtrlName_Change()
Me!TabCtrlName.Value = 0
Call HandlePages
Me![pge1].Value = True
End Sub

In this case I assumed page 1 (index 0) should always be presented so I set
the focus there and popped up all buttons in HandlePages and then pressed
page1 button. (All invisible to the user. The screen just stayes the same.)

 

[Kenny-Z]

I use the same style for one of my apps.
I have to confess I never noticed that behavior.

I took a quick look at it and noticed:
1. When I click on the first button and then Ctrl-Tab the focus moves from
button to button but the page does not change. (This is good.)

2. After the LAST button, Ctrl-Tab moves focus to the Tab Contro itself (I
think - didn't really verify.)
But from that point on, Ctrl-Tab caused the screens to change just as if the
user clicked the buttons, but the buttons were all "wrong" for the current
screen. (This is very bad.)

3. The Tab change event fires when you Ctrl-Tab past the last button.
Aha! We can intercept the event and fix things!

Maybe I'm not following your scenario perfectly, but thanks for the
suggestions.
One of my attempted solutions was to try intercepting the tab control
change event, however, my command buttons (Back, Next, etc.) change
the tab ctl programmatically, firing the event also.

I'm guessing your HandlePages routine sets the button (and other
control) states for the given page. Perhaps this would be a work
around I could try (again).

regards,

Ken

Private Sub TabCtrlName_Change()
Me!TabCtrlName.Value = 0
Call HandlePages
Me![pge1].Value = True
End Sub

In this case I assumed page 1 (index 0) should always be presented so I set
the focus there and popped up all buttons in HandlePages and then pressed
page1 button. (All invisible to the user. The screen just stayes the same.)
--
Joe Fallon
Access MVP

(Repost from microsoft.public.access.gettingstarted, Sunday, August
03)

I use and Access 2000 tab control with tab style 'none', command
buttons and VBA for a wizard. The problem is that Ctrl-Tab will change
the tab control value (page) when it (or child control) has focus. Any
suggestions?

thanks,

kz

 

[Joe Fallon]

You guess is correct.
I didn't explain it very clearly, but I thought we had the same situation so
you would see what I was getting at.
I have 5 buttons that act as Tabs.
The click event of each button calls HandlePages which just re-sets them
all.
(Pops the buttons "up").
Then the click event of the current button pushes in the current button and
activates the correct Tab page.
--
Joe Fallon
Access MVP

I use the same style for one of my apps.
I have to confess I never noticed that behavior.

I took a quick look at it and noticed:
1. When I click on the first button and then Ctrl-Tab the focus moves from
button to button but the page does not change. (This is good.)

2. After the LAST button, Ctrl-Tab moves focus to the Tab Contro itself (I
think - didn't really verify.)
But from that point on, Ctrl-Tab caused the screens to change just as if the
user clicked the buttons, but the buttons were all "wrong" for the current
screen. (This is very bad.)

3. The Tab change event fires when you Ctrl-Tab past the last button.
Aha! We can intercept the event and fix things!

Maybe I'm not following your scenario perfectly, but thanks for the
suggestions.
One of my attempted solutions was to try intercepting the tab control
change event, however, my command buttons (Back, Next, etc.) change
the tab ctl programmatically, firing the event also.

I'm guessing your HandlePages routine sets the button (and other
control) states for the given page. Perhaps this would be a work
around I could try (again).

regards,

Ken

Private Sub TabCtrlName_Change()
Me!TabCtrlName.Value = 0
Call HandlePages
Me![pge1].Value = True
End Sub

In this case I assumed page 1 (index 0) should always be presented so I set
the focus there and popped up all buttons in HandlePages and then pressed
page1 button. (All invisible to the user. The screen just stayes the same.)
--
Joe Fallon
Access MVP

(Repost from microsoft.public.access.gettingstarted, Sunday, August
03)

I use and Access 2000 tab control with tab style 'none', command
buttons and VBA for a wizard. The problem is that Ctrl-Tab will change
the tab control value (page) when it (or child control) has focus. Any
suggestions?

thanks,

kz