Tab form

S

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
 
J

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
 
S

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,
 
L

Larry Linson

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

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
 
S

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
 
L

Larry Linson

Smiley said:
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 ?
Click to expand...

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
 
S

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
 
L

Larry Linson

Smiley said:
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.
Click to expand...

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
 
S

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
 
Top