Access 2000: Tab Page Question

[Guest]

Hi,

I have created a form with multiple tabbed pages. When I tab through the
fields on the first tabbed page, I am able to tab in the proper order down to
the end of the page. However, when I get to the last field of the first
page, the next tab takes me into a new record, rather than to the first field
of the second tabbed page. Under properties, tab index does not allow me to
include the second tabbed page as part of the tab-ordering.

Does anyone know how to get the 2nd and 3rd pages of my form to appear as
part of the tab index list?

Thanks,
Diana

 

[Douglas J Steele]

Try adding a "dummy" field on the page, and having its GotFocus event move
you to the next page.

 

[Guest]

Thank you for the suggestion. Do you know what expression/code I should
enter into the GotFocus event in order for this to work?

Diana

 

[Douglas J Steele]

NameOfControl.SetFocus

where NameOfControl is the control to which you want focus to move.

 

[Guest]

Hello,

I tried your suggestion using both a dummy text box and a dummy command
button. For both, I got the following message:

"Microsoft Access can't find the Macro 'SMSEntered'"
where 'SMSEntered' is the name of the field that I am trying to set the
focus to.

I used the following:
SMSEntered.SetFocus in the "On Got Focus" property of the dummy command
button.

I would like the tab to jump to the field 'SMSEntered' when I get to the end
of the first tabbed page. Do you know what I am doing wrong? Thank you.

Diana

 

[Douglas J Steele]

Sorry: that should have been

Me.SMSEntered.SetFocus

to let Access know that you're talking about a control on the current form.

 

[Guest]

Hello,

When I enter "me.SMSEntered.SetFocus" into the On Got Focus property of my
dummy command button, Access gives me the following message upon tabbing to
the button:

"The expression On Got Focus you entered as the event property setting
produced the following error: The object doesn't contain the Automation
object 'me.'.
*The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure]. *There may have been an error
evaluating the function, event, or macro."

Do you think the error has something to do with the fact that "SMSEntered"
is on the second tab-page, and maybe the program is only looking for field
names on the first page? I know that for the tab-index, one only sees field
names on the first tab-page.

Diana

 

[Douglas J Steele]

I just dummied together a sample, and it works fine for me.

Where did you put Me.SMSEntered.SetFocus? It needs to be put into a VBA
module, not as the entry on the Properties sheet. In other words, assuming
your dummy command button is named cmdDummy, you'll have something like:

Private Sub cmdDummy_Enter()
Me.SMSEntered.SetFocus
End Sub


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hello,

When I enter "me.SMSEntered.SetFocus" into the On Got Focus property of my
dummy command button, Access gives me the following message upon tabbing to
the button:

"The expression On Got Focus you entered as the event property setting
produced the following error: The object doesn't contain the Automation
object 'me.'.
*The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure]. *There may have been an error
evaluating the function, event, or macro."

Do you think the error has something to do with the fact that "SMSEntered"
is on the second tab-page, and maybe the program is only looking for field
names on the first page? I know that for the tab-index, one only sees field
names on the first tab-page.

Diana

Sorry: that should have been

Me.SMSEntered.SetFocus

to let Access know that you're talking about a control on the current form.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


the
end you.
proper
order not
allow to
appear

 

[Guest]

Works wonderfully. Thank you. My problem was that I wasn't entering into
the VBA module.

I just dummied together a sample, and it works fine for me.

Where did you put Me.SMSEntered.SetFocus? It needs to be put into a VBA
module, not as the entry on the Properties sheet. In other words, assuming
your dummy command button is named cmdDummy, you'll have something like:

Private Sub cmdDummy_Enter()
Me.SMSEntered.SetFocus
End Sub


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hello,

When I enter "me.SMSEntered.SetFocus" into the On Got Focus property of my
dummy command button, Access gives me the following message upon tabbing to
the button:

"The expression On Got Focus you entered as the event property setting
produced the following error: The object doesn't contain the Automation
object 'me.'.
*The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure]. *There may have been an error
evaluating the function, event, or macro."

Do you think the error has something to do with the fact that "SMSEntered"
is on the second tab-page, and maybe the program is only looking for field
names on the first page? I know that for the tab-index, one only sees field
names on the first tab-page.

Diana

Sorry: that should have been

Me.SMSEntered.SetFocus

to let Access know that you're talking about a control on the current form.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Hello,

I tried your suggestion using both a dummy text box and a dummy command
button. For both, I got the following message:

"Microsoft Access can't find the Macro 'SMSEntered'"
where 'SMSEntered' is the name of the field that I am trying to set the
focus to.

I used the following:
SMSEntered.SetFocus in the "On Got Focus" property of the dummy command
button.

I would like the tab to jump to the field 'SMSEntered' when I get to the
end
of the first tabbed page. Do you know what I am doing wrong? Thank you.


Diana



:

NameOfControl.SetFocus

where NameOfControl is the control to which you want focus to move.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Thank you for the suggestion. Do you know what expression/code I
should
enter into the GotFocus event in order for this to work?

Diana

:

Try adding a "dummy" field on the page, and having its GotFocus
event
move
you to the next page.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Hi,

I have created a form with multiple tabbed pages. When I tab
through
the
fields on the first tabbed page, I am able to tab in the proper
order
down
to
the end of the page. However, when I get to the last field of the
first
page, the next tab takes me into a new record, rather than to the
first
field
of the second tabbed page. Under properties, tab index does not
allow
me
to
include the second tabbed page as part of the tab-ordering.

Does anyone know how to get the 2nd and 3rd pages of my form to
appear
as
part of the tab index list?

Thanks,
Diana