Tab control versus thick designer! 1

[ChrisTheAncient]

A well-worn topic, I know. But I am now going round in ever decreasing circles - and we all know what happens then!

I'm writing a database in AccessXP - which will need a save in A97 as well.

I have played quite a bit with various other threads that explain about making 'coloured tabs' etc. But can I get them to work? Can I heck!

I've tried various combinations on the Me.Page1.SetFocus scenario and I've tried various combinations on the Me.TabCtl1 scenario. All to no avail. Ergo, I'm doing something very wrong at a very basic level!

So, can I start in a very simple level and say...

If I make a clickable 'thing' of whatever shape or form on my multi-tabbed form, what code do I need in the module for that form to change to another tab - say Page2 ?

Please stop me from taking my frustrations out on either the wife or the cat!

TIA

Chris

*************************************
OK, I'm stoopid. But I'm good at it!
*************************************

 

[danvlas]

Let the cat alone...Wife...that's another thing

Me.TabControlName = 0 will display the first tab
Me.TabControlName = 1 will display the second tab

Me.TabControlName = intTabToOpen will display the tab having the index of the intTabToOpen variable.

So...the cat is surely NOT guilty...

Good luck



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[ChrisTheAncient]

Hi Daniel.

Thanks for coming back.

I made a button on my form, called up the On_Click() in the Form's module, pasted in Me.TabControlName = 1 and got...

Compile Error

Method or data member not found.

See, I said I was stoopid!

And the line before pronouncing the cat not guilty has really lost me.

So, I'm still doin' sumfink daft!

Chris


*************************************
OK, I'm stoopid. But I'm good at it!
*************************************

 

[ChrisTheAncient]

Aaahh...

Another read makes that line I intitially didn't understand now understood!

But not the first bit!

Chris

*************************************
OK, I'm stoopid. But I'm good at it!
*************************************

 

[danvlas]

TabControlName must be the name of your tab control...I just posted an example...



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[ChrisTheAncient]

Gotcha!

Now it works!!!!

The cat (and wife) are safe at last!

Daniel, many, many thanks.

A star for you.

As an aside, I'm now going to spend a while looking at your site because your mailer looks like an answer to my prayer on another problem I had. But that's another story!

Keep up the good work and thanks for keeping me sane

Chris



*************************************
OK, I'm stoopid. But I'm good at it!
*************************************