Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

Access 2003: How to add link or button to a tabbed form to take user to the next Page?

I have a tabbed control on a form.  The tabbed control consists of just 2 pages; however, the pages are a bit long, as I am trying to mirror the paper copy of a form exactly.  I have two questions:

1. I would like to place a link or a button at the bottom of Page 1, named "Continue to Page 2", and which will automatically put them at the top of Page 2 in the tab control on the form.  How can I do this?

2. Is it possible for the tab control Tabs themselves to appear at both the top and the bottom of the tab control (currently they only display at the top)?

thank you!
0
sah18
Asked:
sah18
4 Solutions
 
mbizupCommented:
1. In the click event of your command button, add the following code:

me.Page2.Setfocus  

2. AFAIK, No.
0
 
mbizupCommented:
You can also set the focus to a specific control at the top of page2 (you don't need to specify the page number in the code):

me.YourFirstControlname.SetFocus
0
 
sah18Author Commented:
mbizup - this is great!  do you happen to know if it has to be a button control to do this?  is it possible to have a link instead?

does anyone else know if my second question is possible?

thanks!
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
dannywarehamCommented:
>>does anyone else know if my second question is possible?

Yep.

You can't have the tab control buttons at the bottom and top.
However, you can cheat...

Creat yourself some toggle buttons to look like your tabs.
Place at the bottom of your tab control.

Now you can use the onclick events to move tabs, and use the tab change (when a tab control has focus) to toggle your toggles (if that makes sense).
0
 
jefftwilleyCommented:
Q2,
There are some activeX tab controls where you can choose where to display the "tab" parts (left side, right side, bottom). But in order to set that property, you have to be in design view...this cannot be done at runtime. so you're pretty much stuck navigating either with buttons, after_update events, or actual tab clicks. Sorry,
J
0
 
Leigh PurvisDatabase DeveloperCommented:
You can always make it pretty generic alternatively..
This will continuously cycle through the pages.

Me.TabCtlName.Value = (Me.TabCtlName.Value + 1) Mod (Me.TabCtlName.Pages.count)


On your other point, I know that your second question isn't possible - not with the native control.
0
 
sah18Author Commented:
thanks to everyone for your help!  i've split the points.
0
 
mbizupCommented:
glad to help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now