(Msg. 1) Posted: Thu Jul 24, 2008 2:03 pm
Post subject: Tab Controls/Subforms Add to elertz Archived from groups: microsoft>public>access>tablesdbdesign (more info?)
I'm hoping anyone can help me... I am currently re-designing our company
database and per their preference they want the database to have the tabbed
controls to navigate. The problem I am having, due to trying to minimize
size, I need the Subforms contained on these tabs to be deactivated until the
Tab/Page is selected; however, it does not recognize for some reason the
onclick when you selec the tab, it has to actually be clicked on the page.
If anyone has any pointers... I would greatly appreciate it!!!!!
--
Amanda
(Msg. 2) Posted: Thu Jul 24, 2008 2:14 pm
Post subject: Re: Tab Controls/Subforms Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Amanda
One way to do that is to use an OnChange event procedure for the control
(the tab control, the whole thing, not a page on it). You could use
something like:
Select Case Me!tabYourTabControl.Value 'which tab was clicked
Case 0 'the first tab was clicked
'do something
Case 1 'the second tab ...
'do something else
...
End Select
Good luck!
Regards
Jeff Boyce
Microsoft Office/Access MVP
"amanda_jb" <amandajb.DeleteThis@discussions.microsoft.com> wrote in message
news:B53255E0-1B71-4793-B8FA-B95A062F9226@microsoft.com...
> I'm hoping anyone can help me... I am currently re-designing our company
> database and per their preference they want the database to have the
> tabbed
> controls to navigate. The problem I am having, due to trying to minimize
> size, I need the Subforms contained on these tabs to be deactivated until
> the
> Tab/Page is selected; however, it does not recognize for some reason the
> onclick when you selec the tab, it has to actually be clicked on the page.
>
> If anyone has any pointers... I would greatly appreciate it!!!!!
> --
> Amanda
(Msg. 3) Posted: Fri Jul 25, 2008 3:00 am
Post subject: Re: Tab Controls/Subforms Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Amanda
Use the Change event (not the Click event) of the tab control.
--
Good Luck
Graham Mandeno [Access MVP]
Auckland, New Zealand
"amanda_jb" <amandajb DeleteThis @discussions.microsoft.com> wrote in message
news:B53255E0-1B71-4793-B8FA-B95A062F9226@microsoft.com...
> I'm hoping anyone can help me... I am currently re-designing our company
> database and per their preference they want the database to have the
> tabbed
> controls to navigate. The problem I am having, due to trying to minimize
> size, I need the Subforms contained on these tabs to be deactivated until
> the
> Tab/Page is selected; however, it does not recognize for some reason the
> onclick when you selec the tab, it has to actually be clicked on the page.
>
> If anyone has any pointers... I would greatly appreciate it!!!!!
> --
> Amanda
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office Other