Moving between pages of tabs in a form

[forest8]

Hi there

I have created a form which has 5 tab pages.

I want to create an event in which I can preview the results of the five
tabs by first viewing the first page, then the second, third, and so on.

I'm not sure how to do this.

Essentially, I want to be able to see whether all 5 pages have been filled
correctly.

Thank you in advance.

 

[Clifford Bass via AccessMonster.com]

Hi,

I am confused. How does what you want to do differ from just clicking
on each of the tabs in succession?

Clifford Bass

 

[John W. Vinson]

Hi there

I have created a form which has 5 tab pages.

I want to create an event in which I can preview the results of the five
tabs by first viewing the first page, then the second, third, and so on.

I'm not sure how to do this.

Essentially, I want to be able to see whether all 5 pages have been filled
correctly.

Thank you in advance.

One thing to consider: the data is NOT stored on your form or in your tabs.
It's in your table. The form (tabs or no) is just a window on the data in the
table.

That said... do you have SO MANY fields that you need five tabs to show them??
If so, your table is almost certainly incorrectly designed. Thirty fields is a
*VERY* wide table.

If you have a different Subform on each tab, that's a bit less
anxiety-provoking, but be aware that the records will already have been saved
to disk (as soon as you move the focus from form to subform or vice versa).

I would expect that the user would want to do *something* - click a button,
for example - when they have finished reviewing a page. If so... why not just
click the next tab? What user interaction were you considering?

 

[forest8]

I want to set up 1 single click so that it cycles through the oages,

 

[Piet Linden]

You have to tweak this to tell it to stop... it loops all the way
through the tabs continuously. Happy tweaking.

Option Compare Database
Private iTab As Integer

Private Sub Form_Timer()
iTab = iTab + 1
Dim tabNo As Integer

tabNo = iTab Mod Me.TabCtl0.Pages.Count

Me.TabCtl0.Pages(tabNo).SetFocus

End Sub

 

[Piet Linden]

Hi there

I have created a form which has 5 tab pages.

I want to create an event in which I can preview the results of the five
tabs by first viewing the first page, then the second, third, and so on.

I'm not sure how to do this.

Essentially, I want to be able to see whether all 5 pages have been filled
correctly.

Thank you in advance.

Why do you want to manually preview all the data? If it were my job,
I would write a validation routine that returned a boolean which
toggled a red/green light or something stupid. If I don't have to
look at the data, I won't. I'll let the computer do it for me.

 

[Clifford Bass via AccessMonster.com]

Hi,

And what happens when a particular tab goes by too fast and the user
starts swearing because there is no way to halt the process or back up?
Things interrupt people and they need to be able to pause. For one person
five seconds per tab may be plenty and for another it may be too short. So,
at least provide a way to halt, back up, and to set the time period.

Clifford Bass

 

[John W. Vinson]

I want to set up 1 single click so that it cycles through the oages,

I'd be inclined to put a "next page" button on each page, in the same place,
so the user can hold the mouse at one position and click once for each page. I
agree that just having the pages automatically scroll by would be too slow, or
too fast, or BOTH.

 

[forest8]

Thank you to everyone who've responded to my question. As a Novice Access
user, it is good to for me hear more expert advace.

 

[Clifford Bass via AccessMonster.com]

Hi,

You are welcome! Good luck with the project.

Clifford Bass