Entering data per person instead of per table ?!

Hi there,

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

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

I hope I have made clear what I mean. Pleas explain to me=20
as if I'm a 12-year old, beacuse I am not really familiar=20
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


"Indira" wrote in message
...
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 a
- 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=20
actually perform the task :-)=20
I don't quite understand what you mean by IN or OUTSIDE,=20
but I will take a book at hand..

Indira.


-----Original Message-----
Hi,


Yes.


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

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


Hoping it may help,
Vanderghast, Access MVP


"Indira" wrote in=20
message=20
...
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=E9n go to the
med.his form and fill in the data for the first person,
and th=E9n go to the smoking behavior form and enter the
data for the first person. Only th=E9n do I want to go to
the second person, etc..

So my questions a
- 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.=20


.

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


"Indira" wrote in message
...
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.


-----Original Message-----
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


"Indira" wrote in
message
...
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 a
- 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.


.