can I make 3 tabbed forms?

[Guest]

I have too many fields in a table and I have to fill them for all records.
All fields don't fit to a single form so I decided to split them in 3 tabbed
forms. I can make 2 tabbed forms using the control in toolbox but I couldn't
find a place to make 3 tabbed forms. Are they restricted only to 2 tabbed
forms?
Is my design criteria corrrect to look for 3 tabbed forms or I have to
reconsider making 3 tabbed forms.

 

[Rob Parker]

You can add additional pages to a tab control, to get more than the default
of two. WIth the tab control selected, right-click and choose "Insert
Page".

A common reason for people having too many fields to fit on a single form is
that their table design is incorrect, and they have more fields than is
necessary with a properly normalised data structure.

Rob

 

[John W. Vinson]

I have too many fields in a table and I have to fill them for all records.

Then you almost surely have an incorrectly designed table. I needed 62 fields
in a table... once, in 15 years of database design (in Oracle and Access).

What's the structure of your table? I suspect that you have one or more
one-to-many relationships embedded in each record.

All fields don't fit to a single form so I decided to split them in 3 tabbed
forms. I can make 2 tabbed forms using the control in toolbox but I couldn't
find a place to make 3 tabbed forms. Are they restricted only to 2 tabbed
forms?

I believe that there is a limit of 64 tabs on a tab control. Select the tab
control in design mode and choose Insert from the menu.


John W. Vinson [MVP]

 

[Guest]

Dear John

Thanks for your input.

Regarding the design of the database, after finishing the design I
understood that it is not good. Let me explain what is my aim and how did I
design it, so maybe you can give some hints.
What is the aim?
I have a health questionnaire, which is filled in clinics and I want to
input them into access and later I will analyze them statistically. This
questionnaire contains 31 questions and I have put all of them in one table.
Patients are categorized into two types, namely desk-work patients and
non-desk-work patients.

Questions are as follows:
1) Name, Gender, Age, education, patient type, clinic name (totally 8
questions)
2) 5 questions about smoking habits of patient, like:
Do you smoke? How many per day?, For how long do you smoke?
3) 2 questions about sporting activity
4) 4 questions about disease history, like:
Do you have CHD?
If yes, please explain
Do you have Diabetes?
If yes, please explain
5) 8 questions which should be measured like:
Height, Weight, Waist, hips, blood pressure, blood rate
6) 6 questions which need a test, and its result will be input like:
Cholesterol, Glucose, Insulin

Structure of my db:
TblClinic
ClinicID
ClinicName
ClinicAddress
And some other

TblPatientType
ClinicID
PatientTypeID
PatientType (has only two options, desk-work patients and non-desk-work
patients)

TblMain
PatientTypeID
And then most of above-mentioned questions except for those which are
mentioned in above tables.


My relationships are defined as follows:
A one to many relation from Clinic Table to PatientType Table
A one to many relation from PatientType Table to main Table.

I want to design a form for data-entry purpose. Questionnaire comes in the
following order.
Questionnaire for each clinic come separately.
Then for each clinic, type of patients is separated.
So in my form, I want to have 2 subforms in my main form. In the main form,
I want to input clinic name, then in the first subform, I want to input
patient type and finally in second subform to enter all main data.
The reason for this method to design the form, is to ease the data entry.
Let say for 30 patients (10 is type one and 20 is type 2) in clinic A, I want
to enter the clinic name only once for all 30 patients. Then enter patient
type once and then only fill the 2nd subform.

Any help is highly appreciated.

 

[John W. Vinson]

I have a health questionnaire, which is filled in clinics and I want to
input them into access and later I will analyze them statistically. This
questionnaire contains 31 questions and I have put all of them in one table.

Yes... *AS 31 RECORDS* in a related table, not as 31 fields.

See
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'
for an example of how to do this correctly.


John W. Vinson [MVP]