Tab form

[Smiley]

Hi Everyone,

Just discover the Tab form which I would like to use but can't see where I
would put in a conditional selection.

I want items be grouped and thinking of using Tab Form, so I would have one
tab which is for Person a, another tab which is for Person B, another one
for person C etc.

All the contents to be showed on each Tab is same except the name of the
person who does the job. As the data for all tabs are from one single table.
I have tried to put event procedure When click to select the person's name
but it doesn't work. Where have I gone wrong ?

Many thanks,

Rach

[Jeff Smith]

That is not what a tab control is for. A tab is for grouping controls not
records. What happens if you have 50 persons? What about 300 persons? What
will you do when you add another person?

Jeff
"Smiley" <Ra**@akita.co.ukwrote in message
news:eo*******************@news.demon.co.uk...

Hi Everyone,

Just discover the Tab form which I would like to use but can't see where I
would put in a conditional selection.

I want items be grouped and thinking of using Tab Form, so I would have
one tab which is for Person a, another tab which is for Person B, another
one for person C etc.

All the contents to be showed on each Tab is same except the name of the
person who does the job. As the data for all tabs are from one single
table. I have tried to put event procedure When click to select the
person's name but it doesn't work. Where have I gone wrong ?

Many thanks,

Rach

[Smiley]

Hi Jeff,

Thanks for pointing out how tab control is used.

Any idea how I would achieve the result that I want ?

Many thanks,

"Jeff Smith" <No****@not.this.addresswrote in message
news:45********@clear.net.nz...

That is not what a tab control is for. A tab is for grouping controls not
records. What happens if you have 50 persons? What about 300 persons? What
will you do when you add another person?

Jeff
"Smiley" <Ra**@akita.co.ukwrote in message
news:eo*******************@news.demon.co.uk...

>Hi Everyone,

Just discover the Tab form which I would like to use but can't see where
I would put in a conditional selection.

I want items be grouped and thinking of using Tab Form, so I would have
one tab which is for Person a, another tab which is for Person B, another
one for person C etc.

All the contents to be showed on each Tab is same except the name of the
person who does the job. As the data for all tabs are from one single
table. I have tried to put event procedure When click to select the
person's name but it doesn't work. Where have I gone wrong ?

Many thanks,

Rach

[Larry Linson]

"Smiley" <Ra**@akita.co.ukwrote in message
news:eo*******************@news.demon.co.uk...

Thanks for pointing out how tab control is used.
Any idea how I would achieve the result that I want ?

Yes, that is what Continuous Forms View is designed to show.

Create a shallow form with one line or a few lines per record, then in the
Format tab of the Property Sheet for the Form, look for Default View, and
set it to Continuous Forms.

You can code so that double-clicking, or clicking on a Command Button, on a
line will use the unique identifier for that Record to open a Single-Form
View Form (could be a Popup Dialog if you'd like) showing the details of the
selected Record.

Larry Linson
Microsoft Access MVP

[Smiley]

Is there a tidier way which I would have it all on one screen. I only got a
few people and only a few item of each. I want to see everyone's on one
screen, so I got this idea to use tab control. Any other way I would view
all on one screen or more or less on one screen ?

Regards
"Larry Linson" <bo*****@localhost.notwrote in message
news:ecRqh.6464$Gj5.1660@trnddc01...

"Smiley" <Ra**@akita.co.ukwrote in message
news:eo*******************@news.demon.co.uk...

Thanks for pointing out how tab control is used.
Any idea how I would achieve the result that I want ?

Yes, that is what Continuous Forms View is designed to show.

Create a shallow form with one line or a few lines per record, then in the
Format tab of the Property Sheet for the Form, look for Default View, and
set it to Continuous Forms.

You can code so that double-clicking, or clicking on a Command Button, on
a line will use the unique identifier for that Record to open a
Single-Form View Form (could be a Popup Dialog if you'd like) showing the
details of the selected Record.

Larry Linson
Microsoft Access MVP

[Larry Linson]

"Smiley" <Ra**@akita.co.ukwrote

Is there a tidier way which I would have it all on one screen. I only got

a

few people and only a few item of each. I want to see everyone's on one
screen, so I got this idea to use tab control. Any other way I would view
all on one screen or more or less on one screen ?

If there are few enough, instead of using the continuous forms view to
select, you can include all the fields, see the details, and update directly
from the continuous forms view. It is scrollable, so although not everything
may be visible at all times, it really fits the definition of one screen
better than a Tab Control does.

I don't see any difference, in fact, between "multiple screens" and
"multiple pages" of a Tab Control.

Larry Linson
Microsoft Access MVP

[Smiley]

Hi Larry,

If I put it in one page, anyway I would achieve like the conditional
formating as in Excel, so I would associate each person with a colour. If
so, please give me some idea where to begin. I am very new to this.

Many thanks,

Rach

"Larry Linson" <bo*****@localhost.notwrote in message
news:vm8rh.4338$9B6.2871@trnddc07...

"Smiley" <Ra**@akita.co.ukwrote

Is there a tidier way which I would have it all on one screen. I only
got

a

few people and only a few item of each. I want to see everyone's on one
screen, so I got this idea to use tab control. Any other way I would
view
all on one screen or more or less on one screen ?

If there are few enough, instead of using the continuous forms view to
select, you can include all the fields, see the details, and update
directly from the continuous forms view. It is scrollable, so although not
everything may be visible at all times, it really fits the definition of
one screen better than a Tab Control does.

I don't see any difference, in fact, between "multiple screens" and
"multiple pages" of a Tab Control.

Larry Linson
Microsoft Access MVP

[Larry Linson]

"Smiley" <Ra**@akita.co.ukwrote

If I put it in one page, anyway I would achieve like the conditional
formating as in Excel, so I would associate each person with a colour. If
so, please give me some idea where to begin. I am very new to this.

Right-click the Control in Design View of the Report, and choose Conditional
Formatting. That will provide you the conditional formatting that Access
supports.

Just a comment: a database is not a spreadsheet. It was likely a design
assumption for Access that users would be handling more records than would
be convenient to assign each record a separate, different color. Because,
while Access can easily handle a few records in a table, its real value is
handling hundreds, or thousands, or even millions of records.

Larry Linson
Microsoft Access MVP

[Smiley]

Hi Larry,

Thank you for the advice and comment.

I have tried it but not achieving. It would be due to something which I have
not set properly. Will bash on.

Have a good day,

rach
"Larry Linson" <bo*****@localhost.notwrote in message
news:JdZsh.436$FN1.199@trnddc08...

"Smiley" <Ra**@akita.co.ukwrote

If I put it in one page, anyway I would achieve like the conditional
formating as in Excel, so I would associate each person with a colour.
If
so, please give me some idea where to begin. I am very new to this.

Right-click the Control in Design View of the Report, and choose
Conditional Formatting. That will provide you the conditional formatting
that Access supports.

Just a comment: a database is not a spreadsheet. It was likely a design
assumption for Access that users would be handling more records than would
be convenient to assign each record a separate, different color. Because,
while Access can easily handle a few records in a table, its real value is
handling hundreds, or thousands, or even millions of records.

Larry Linson
Microsoft Access MVP