Putting table data into specific areas of a pasted form

[_Bigred]

Using Access 2000 (will be running db on Access 97)

I have a form I pasted into Access that is a room chart:
1)it basically is designed to show what room each person is in.
2)What date they were placed in the room,
3)If they have any medical restriction (Lower bunk, upper bunk, deaf, blind
etc..)
4)And a patient ID Number

The layout of the form needs to remain true to the actual layout of the
facility, but is there a way for me to identify an area on the form as (for
example) as Room N056 (Upper or U), and then have the data in my table put
the person that is designated in this room and bunk assignment put on the
form where the room is shown?

Ultimately I would like to be able to edit my patient table using a Data
Entry form, then have the room charts update to show 1,2,3,4 listed above.
Without having to manually "frequently" modify a word document. If I can do
it automatically in Access this would be the route I would LOVE to take.

Any ideas would be greatly appreciated, I would like to keep the Data Entry
& Data Deletion simple for the end user. This database is stored on only (1)
computer so it will be a access database store in a folder.

TIA,
_Bigred

 

[Klatuu]

Trying to model a three dimensional world in a two dimensional medium can be
tricky. Until Access 3D is released, you will have to find another way
What kind of control do you use to identify a room? Do you have a way to
identify a bunk in that room?
What I am thinking is using special effects for a control, like Sunken for
lower and Raised for Upper. Without more info, can't be too specific, but
this is a really interesting problem.

 

[_Bigred]

Well at present I don't have the upper bunk & lower bunk identified, but I
could identify them as
Example: N054U or N054L. The problem being I would need the data to be
placed in the proper box on a report or form - for printing purposes (where
they are housed i.e. certain room number (and upper or lower bunk).

I would ultimately need the report (printed on 8-1/2 x 11 paper), and the
layout of the boxes on the form have to remain in a very specific
configuration because it reflects the order of rooms in the facility.

I guess if a draw a square on a form or report, can I designate it as box
number N054U and then have the data from a table get printed in that box
(provided in the table it indicates they are in room N054U)?

What do you think?
_Bigred

 

[_Bigred]

Or I guess I would probably ask is there a way that I can put a draw a box
in design view of a form or report and label it N054U then have the data
from a table that match room N054U displayed in that box?

Thanks Again,
_Bigred

 

[Klatuu]

I think that is a good approach. You have a difficult situation.

 

[Klatuu]

I'm not sure what you mean by "put a draw a box". Do you mean a Text Box?
Sure, you could do that. I do have some thoughts; however, how large is your
facility? In other words, how many rooms, how many bunks, how do you
associate a patient with a room/bunk. How do you assign the
attributes/restrictions of the patient you mentioned in your original post to
the room/bunk? This is some pretty tricky matching. If your facility is
large, it could cause you some headaches in table design.

 

[_Bigred]

Yes, I was thinking maybe a text box would do the trick?

Basically the facility contains the following:
164 People
88 Total Rooms (Of which 44 Are Double Occupancy, 44 are Single occupancy)

Medical Restrictions are noted by our health services people based on need
(so they can change from time to time), these restrictions could be any of
the following:
LB (Lower Bunk)
LT (Lower Tier)
LB/LT (Lower Bunk/Lower Tier)
LB/LT/C (Lower Bunk/Lower Tier w/Chair)
Deaf
Blind

Idea of what 1 of 4 room chart would look like is:
North Dayroom has (3) columns on a sheet
Column a has 9 double rooms
Column b has 7 double rooms
Column c has 1 double room.
so i will try to demonstrate the layout with text below:

236 053 054
235 052
234 051
233 050
232 049
231 048
230 047
229
228
On the sheet above they are all double occupancy rooms, printed on a
8-1/2x11 paper. (However on 3 of the 4 room charts there are single rooms,
and the layout varies basic on the layout of the facility).

thanks,
_Bigred

 

[Klatuu]

Okay, I was just thinking in terms of size and flexibility, but there is no
real problem here. You just need to identify the attributes in the table
where you keep info on bunks/rooms to match patients. Using the layout you
posted, would this work>

236U 053U 054U
236L 053L 054L
235U 052U
235L 052L
234U 051U
234L 051L
233U 050U
233L 050L
232U 049U
232L 049L
231U 048U
231L 048L
230U 047U
230L 047L
229L
229U
228U
228L

I can't think of another way to do it easily. I just had an inspirational
flash, but I don't know what your experience level is and it takes a little
VBA coding and would probably mess up your current form, but my Idea is for
each room that is double occupancy, create an option group with two toggle
buttons(looks more like a bed than a radio button) and mark them Upper and
Lower. Below the toggle buttons, put a text box that will show the name of
the patient for the toggle button selected. You could then put code in the
After Update event of the option group to put the patient's name in the text
box.

By the way, how will you deal with the 32 patients sleeping on the floor?

44 doubles = 88 + 44 singles = 132 164 -132 = 32

32 text boxes on the floor?