I have two questions:
1. Currently, our patient treatment schedule is in a Word table which
requires manual calculation of treatment dates. The info is then entered
(typed) into the table, and distributed to different parties. Parts of the
table is retyped into second and third "lists" for permanent record. When
treatment is completed, their info is deleted from the Word schedule after
being retyped into another table (whew!)

I have set up an excel worksheet that includes the patient information and
calculates treatment dates. I am using Custom Views to filter information out
for different department and uses. I have a Master Document from which I
created custom views for the schedule, for the outcome record, and one other
record. When a patient's treatment is complete, I would like to hide their
info in the schedule view (all in one row) instead of deleting it as we do
now, so the practitioners are not sorting through a huge list to find pts
currently in treatment. But when I change views, to see the master document,
and return to the schedule view, the hidden row is no longer hidden. What am
I doing wrong?? Is this the best way to set up my project?

2. I set up print areas and page direction (landscape vs portrait) for each
view. Though I figured that out OK, for some reason the schedule - or
whatever view I am printing- prints in a reduced size on the bottom left of
the paper. Is this my page set up or my printer settings? I have tried for
hours to resolve this and haven't been successful...any ideas?

1. select the area to be printed
2. File Print Area Set Print Area
3. File Page Setup... and then adjust both scaling and margins to suit.

--
Gary''s Student - gsnu200793


"Khardy3352" wrote:

I have two questions:
1. Currently, our patient treatment schedule is in a Word table which
requires manual calculation of treatment dates. The info is then entered
(typed) into the table, and distributed to different parties. Parts of the
table is retyped into second and third "lists" for permanent record. When
treatment is completed, their info is deleted from the Word schedule after
being retyped into another table (whew!)

I have set up an excel worksheet that includes the patient information and
calculates treatment dates. I am using Custom Views to filter information out
for different department and uses. I have a Master Document from which I
created custom views for the schedule, for the outcome record, and one other
record. When a patient's treatment is complete, I would like to hide their
info in the schedule view (all in one row) instead of deleting it as we do
now, so the practitioners are not sorting through a huge list to find pts
currently in treatment. But when I change views, to see the master document,
and return to the schedule view, the hidden row is no longer hidden. What am
I doing wrong?? Is this the best way to set up my project?

2. I set up print areas and page direction (landscape vs portrait) for each
view. Though I figured that out OK, for some reason the schedule - or
whatever view I am printing- prints in a reduced size on the bottom left of
the paper. Is this my page set up or my printer settings? I have tried for
hours to resolve this and haven't been successful...any ideas?

Thank you..one problem solved. What do you think of the "hidden row in one
view" issue? I set up a macro in the view that I want hidden rows, but still
wonder if I am developing the most efficient document for what I need. Any
thoughts?

"Khardy3352" wrote:

I have two questions:
1. Currently, our patient treatment schedule is in a Word table which
requires manual calculation of treatment dates. The info is then entered
(typed) into the table, and distributed to different parties. Parts of the
table is retyped into second and third "lists" for permanent record. When
treatment is completed, their info is deleted from the Word schedule after
being retyped into another table (whew!)

I have set up an excel worksheet that includes the patient information and
calculates treatment dates. I am using Custom Views to filter information out
for different department and uses. I have a Master Document from which I
created custom views for the schedule, for the outcome record, and one other
record. When a patient's treatment is complete, I would like to hide their
info in the schedule view (all in one row) instead of deleting it as we do
now, so the practitioners are not sorting through a huge list to find pts
currently in treatment. But when I change views, to see the master document,
and return to the schedule view, the hidden row is no longer hidden. What am
I doing wrong?? Is this the best way to set up my project?

2. I set up print areas and page direction (landscape vs portrait) for each
view. Though I figured that out OK, for some reason the schedule - or
whatever view I am printing- prints in a reduced size on the bottom left of
the paper. Is this my page set up or my printer settings? I have tried for
hours to resolve this and haven't been successful...any ideas?