Add a Tab to a Form (1 Viewer)

access2010

Registered User.
Local time
Yesterday, 16:22
Joined
Dec 26, 2009
Messages
1,021
I have been trying to create an Access 2003 form with two tabs, but have had no success.

Could I please be advised as to what I have done wrong?
Main Form = Investments_Purchases_IncomeF
Tab . Transaction = Investments_Purchases_IncomeF_SubForm
Tab . Bank_Account = Portfolio_Cash_F_LastTwo_Sub
Tab . Other_F_Sub = Other_F_Sub (to be developed)

Can the tab colour be changed?

Thank you,
Crystal
 

Attachments

  • Form_With_2_Tabs=21=070.mdb
    552 KB · Views: 254

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 07:22
Joined
May 7, 2009
Messages
19,231
before you add a Form (as subform) to the Tab control:
1. Click first the Tab you want to add the form.
2. Drag the Form you want to add to the Tab control.
Make sure the Inside background of the area of the Tab control
turns Black.
3. Drop the Form to the Black area.
 

Attachments

  • Form_With_2_Tabs=21=070.mdb
    1,008 KB · Views: 261

access2010

Registered User.
Local time
Yesterday, 16:22
Joined
Dec 26, 2009
Messages
1,021
before you add a Form (as subform) to the Tab control:
1. Click first the Tab you want to add the form.
2. Drag the Form you want to add to the Tab control.
Make sure the Inside background of the area of the Tab control
turns Black.
3. Drop the Form to the Black area.
Thank you arnelgp.
Your suggestions are 99%.

For some reason Two of the Tab Sub forms are not showing the same values as they do in their form View.

Can the tabs be different colours in our Access 2003?

Thank you.
Crystal
 

MajP

You've got your good things, and you've got mine.
Local time
Yesterday, 19:22
Joined
May 21, 2018
Messages
8,525
Can the tabs be different colours in our Access 2003?
You can fake it, but there is no built in way to do it.
To fake it you use a tab control, but format it so there is no tabs. Then in place of tabs you use labels. It works, but it is extra work for not much benefit. Here is a demo
 

Attachments

  • MajP TabControlColor.mdb
    464 KB · Views: 249

access2010

Registered User.
Local time
Yesterday, 16:22
Joined
Dec 26, 2009
Messages
1,021
You can fake it, but there is no built in way to do it.
To fake it you use a tab control, but format it so there is no tabs. Then in place of tabs you use labels. It works, but it is extra work for not much benefit. Here is a demo
Thank you, MajP
P.E.R.F.E.C.T..
cRYSTAL
 

access2010

Registered User.
Local time
Yesterday, 16:22
Joined
Dec 26, 2009
Messages
1,021
Thank you arnelgp.
Your suggestions are 99%.

For some reason Two of the Tab Sub forms are not showing the same values as they do in their form View.

Can the tabs be different colours in our Access 2003?

Thank you.
Crystal
The Tab Forms Hold the Proper Sub Forms, but the Sub Form data is not correct.

Investments_Purchases_IncomeF = Main Form
The data shown is correct
Could a new Blank Record be created at the TOP of the form when the New Button is Clicked?

Tab 2
This page should show ONLY the TWO most current records.

Tab 3
This tab should show ALL of the records.
Could there be a relationship filter that only shows the records with a portfolio code of BNS as ALL Portfolio Codes SHOULD be shown?
Could a new Blank Record be created at the TOP of the form when the New Button is Clicked?


I will appreciate your advice on the above
Crystal
 

Attachments

  • Form_With_2_Tabs=21=072.mdb
    640 KB · Views: 284

access2010

Registered User.
Local time
Yesterday, 16:22
Joined
Dec 26, 2009
Messages
1,021
before you add a Form (as subform) to the Tab control:
1. Click first the Tab you want to add the form.
2. Drag the Form you want to add to the Tab control.
Make sure the Inside background of the area of the Tab control
turns Black.
3. Drop the Form to the Black area.
T.H.A.N.K. you for your instructions which we have used many times this week.
Nicole
 

Users who are viewing this thread

Top Bottom