|
 |
access thread: tab statement
Message #1 by "Idelle Grant" <crawleriver@h...> on Fri, 17 Jan 2003 19:40:01
|
|
I have a tab control with 3 pages, Name, Address, Personal and tab index
0,1,2 respectively.
I want to say:
If Address is the Selected Tab Then
'do something
What is the correct syntax to do that ?
Message #2 by "bwarehouse" <bwarehouse@y...> on Sat, 18 Jan 2003 14:28:01 -0700
|
|
try:
If Screen.ActiveControl.Name = tabname THEN
bla,bla,bla
later,
bware
-----Original Message-----
From: Idelle Grant [mailto:crawleriver@h...]
Sent: Friday, January 17, 2003 7:40 PM
To: Access
Subject: [access] tab statement
I have a tab control with 3 pages, Name, Address, Personal and tab index
0,1,2 respectively.
I want to say:
If Address is the Selected Tab Then
'do something
What is the correct syntax to do that ?
Message #3 by John Fejsa <John.Fejsa@h...> on Mon, 20 Jan 2003 08:51:15 +1100
|
|
Two methods you can use.
1) Use a page name (recommended)
If Me!tabMyTabControl.Pages.Item tabMyTabControl.Value).Name
"pgMyTabName" then
do something
......
end if
2) Use an index to refer to a page (not recommended as you could easily
move pages around therefor mixing the index - faster if you know that
you will not add, delete, or change tab pages order)
If Me!tabMyTabControl.Value = 0 then
do something
......
end if
Hope that helps
____________________________________________________
John Fejsa
Systems Analyst/Computer Programmer
Hunter Centre for Health Advancement
Locked Bag 10, WALLSEND NSW 2287
Phone: (02) 4924 6336 Fax: (02) 4924 6209
www.hcha.org.au
____________________________________________________
The doors we open and close each day decide the lives we live
____________________________________________________
CONFIDENTIALITY & PRIVILEGE NOTICE
>>> crawleriver@h... 18/01/2003 6:40:01 >>>
I have a tab control with 3 pages, Name, Address, Personal and tab index
0,1,2 respectively.
I want to say:
If Address is the Selected Tab Then
'do something
What is the correct syntax to do that ?
This message is intended for the addressee named
and may contain confidential information.
If you are not the intended recipient, please
delete it and notify the sender.
Views expressed in this message are those of the
individual sender, and are not necessarily the
views of Hunter Health.
Message #4 by John Fejsa <John.Fejsa@h...> on Mon, 20 Jan 2003 09:29:34 +1100
|
|
Too quick of the mark, first method is missing a open bracket, sorry...
If Me!tabMyTabControl.Pages.Item (tabMyTabControl.Value).Name
"pgMyTabName" then
do something
......
end if
____________________________________________________
John Fejsa
Systems Analyst/Computer Programmer
Hunter Centre for Health Advancement
Locked Bag 10, WALLSEND NSW 2287
Phone: (02) 4924 6336 Fax: (02) 4924 6209
www.hcha.org.au
____________________________________________________
The doors we open and close each day decide the lives we live
____________________________________________________
CONFIDENTIALITY & PRIVILEGE NOTICE
>>> John.Fejsa@h... 20/01/2003 8:51:15 >>>
Two methods you can use.
1) Use a page name (recommended)
If Me!tabMyTabControl.Pages.Item tabMyTabControl.Value).Name
"pgMyTabName" then
do something
......
end if
2) Use an index to refer to a page (not recommended as you could easily
move pages around therefor mixing the index - faster if you know that
you will not add, delete, or change tab pages order)
If Me!tabMyTabControl.Value = 0 then
do something
......
end if
Hope that helps
____________________________________________________
John Fejsa
Systems Analyst/Computer Programmer
Hunter Centre for Health Advancement
Locked Bag 10, WALLSEND NSW 2287
Phone: (02) 4924 6336 Fax: (02) 4924 6209
www.hcha.org.au
____________________________________________________
The doors we open and close each day decide the lives we live
____________________________________________________
CONFIDENTIALITY & PRIVILEGE NOTICE
>>> crawleriver@h... 18/01/2003 6:40:01 >>>
I have a tab control with 3 pages, Name, Address, Personal and tab index
0,1,2 respectively.
I want to say:
If Address is the Selected Tab Then
'do something
What is the correct syntax to do that ?
This message is intended for the addressee named
and may contain confidential information.
If you are not the intended recipient, please
delete it and notify the sender.
Views expressed in this message are those of the
individual sender, and are not necessarily the
views of Hunter Health.
This message is intended for the addressee named
and may contain confidential information.
If you are not the intended recipient, please
delete it and notify the sender.
Views expressed in this message are those of the
individual sender, and are not necessarily the
views of Hunter Health.
|
|
|
View Cart
