A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Vertical Page Tabs



 
 
Thread Tools Display Modes
  #1  
Old June 17th, 2008, 02:35 PM posted to microsoft.public.access.tablesdbdesign
Billiam
external usenet poster
 
Posts: 174
Default Vertical Page Tabs

Is it possible to produce vertical page tabs in Access 2007? I would like my
form to appear like a binder with index dividers on the right hand side.

Thanks,
Billiam
  #2  
Old June 18th, 2008, 10:41 AM posted to microsoft.public.access.tablesdbdesign
Brendan Reynolds
external usenet poster
 
Posts: 1,241
Default Vertical Page Tabs

"Billiam" wrote in message
...
Is it possible to produce vertical page tabs in Access 2007? I would like
my
form to appear like a binder with index dividers on the right hand side.

Thanks,
Billiam



There's no built-in option to change the orientation of the tab control, but
you could set the Style property of the tab control to None (so that it
doesn't display any visible tabs) then use a column of command buttons or
labels down the right side of the form to set the Value property of the tab
control to display the relevant page ...

Private Sub cmdPageOne_Click()
Me.tabTest.Value = 0
End Sub

Private Sub cmdPageTwo_Click()
Me.tabTest.Value = 1
End Sub

Private Sub cmdPageThree_Click()
Me.tabTest.Value = 2
End Sub

Note that the pages collection is zero-based, so set the Value property to 0
to display the first page, 1 to display the second page, etc.

--
Brendan Reynolds

  #3  
Old June 18th, 2008, 01:07 PM posted to microsoft.public.access.tablesdbdesign
Billiam
external usenet poster
 
Posts: 174
Default Vertical Page Tabs

Hi Brendan,

Sorry, I did see another post by you which I had missed before on this
topic. I am going to try this out today. I have never done anything like this
before as I am new to Access. I promise to rate the response and add anything
that might help a newbie like me! Thanks again for your help.
Billiam
"Brendan Reynolds" wrote:

"Billiam" wrote in message
...
Is it possible to produce vertical page tabs in Access 2007? I would like
my
form to appear like a binder with index dividers on the right hand side.

Thanks,
Billiam



There's no built-in option to change the orientation of the tab control, but
you could set the Style property of the tab control to None (so that it
doesn't display any visible tabs) then use a column of command buttons or
labels down the right side of the form to set the Value property of the tab
control to display the relevant page ...

Private Sub cmdPageOne_Click()
Me.tabTest.Value = 0
End Sub

Private Sub cmdPageTwo_Click()
Me.tabTest.Value = 1
End Sub

Private Sub cmdPageThree_Click()
Me.tabTest.Value = 2
End Sub

Note that the pages collection is zero-based, so set the Value property to 0
to display the first page, 1 to display the second page, etc.

--
Brendan Reynolds

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:45 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.