Entering data per person instead of per table ?!

  • Thread starter Thread starter Indira
  • Start date Start date
I

Indira

Hi there,

If I understand correctly, one can enter data using forms
on a so-called row-wise manner. So, if I have data for,
say, 3 persons, and data concerning personal
identification (name, adress, etc..), medical history and
smoking behavior, which all have to be in different
tables, then the only way I can get these data entered is
by first entering the personal id info for the 3 persons,
then the med.his. for the 3, and then the smoking
behavior. However, I want to be able to enter the data for
the first person in the personal id. form, thén go to the
med.his form and fill in the data for the first person,
and thén go to the smoking behavior form and enter the
data for the first person. Only thén do I want to go to
the second person, etc..

So my questions are:
- Is this possible, and if yes, how ?
- Can I have a button on each form, that gives me a choice
if I want to go to the next form or to the next person (in
the same form) ? And how do I create that ?

I hope I have made clear what I mean. Pleas explain to me
as if I'm a 12-year old, beacuse I am not really familiar
with 'IT-talk'.

(In real life, I have 24 persons, and 52 forms, but a 3-
person example is more easy to comprehend)

Thanks,
Indira.
 
Hi,


Yes.


Use a multi-tab control, one "page-tab" by group of info (one tab for
smoking, one tab for med, one tab for personal info), and, in the main form,
outside the tab-control, have the person name (or something like that). To
change of "form", click on the "tab".

The tab control works quite intuitively, In VBA (if you use VBA), do as if
it was not there. Cannot be more simple than that, really. In design, add
the right number of tab, add icon picture if wanted, then, select one of
them, and create the control IN the page of the tab. Customize the page
adding other controls IN the page. Once done, select another "tab", create
the controls in the new page, etc. If you wish to have a control common to
all the tab, create it OUTSIDE the control-tab, then, slide it over the
control-tab. For the logic of you application, do just as if the control was
not there. In fact, that control "just" hide-unhide group of controls,
automatically, for you (well, "almost" do just that). Don't be afraid using
it.


Hoping it may help,
Vanderghast, Access MVP


Hi there,

If I understand correctly, one can enter data using forms
on a so-called row-wise manner. So, if I have data for,
say, 3 persons, and data concerning personal
identification (name, adress, etc..), medical history and
smoking behavior, which all have to be in different
tables, then the only way I can get these data entered is
by first entering the personal id info for the 3 persons,
then the med.his. for the 3, and then the smoking
behavior. However, I want to be able to enter the data for
the first person in the personal id. form, thén go to the
med.his form and fill in the data for the first person,
and thén go to the smoking behavior form and enter the
data for the first person. Only thén do I want to go to
the second person, etc..

So my questions are:
- Is this possible, and if yes, how ?
- Can I have a button on each form, that gives me a choice
if I want to go to the next form or to the next person (in
the same form) ? And how do I create that ?

I hope I have made clear what I mean. Pleas explain to me
as if I'm a 12-year old, beacuse I am not really familiar
with 'IT-talk'.

(In real life, I have 24 persons, and 52 forms, but a 3-
person example is more easy to comprehend)

Thanks,
Indira.
 
Thanks a lot, I think I understand. Now let's try if I can
actually perform the task :-)
I don't quite understand what you mean by IN or OUTSIDE,
but I will take a book at hand..

Indira.
 
Hi,

By "IN" I mean that the area of the control tab change of color as soon
as you begin to add a control and move the mouse cursor over the tab
control. You are "OUTSIDE" when your mouse cursor does NOT change the color
of the tab control.


Hoping it may help,
Vanderghast, Access MVP


Thanks a lot, I think I understand. Now let's try if I can
actually perform the task :-)
I don't quite understand what you mean by IN or OUTSIDE,
but I will take a book at hand..

Indira.
 
Back
Top