Hi
What Stefan is saying is absolutely right. Perhaps if you can post a sample we may be able to provide you with a solution.
Tony(OTPM)

Ok Guys
This is a draft version of the document I am working on to improve patient handovers within the ward I work on. It's only a partial document to meet the limits to attachments but you can see the principal I'm trying to achieve. I've saved it in word 2003 as this is what we run at work.

At the present it doesn't have protection as I found protecting the form disabled the links (patient 1,2 etc command and Back buttons) unless you guys know a way to do this.

I want to add to the bottom of the document either a single cell with headings (patient 1, patient 2 etc) or a 22 row table, which ever works best, again with rows labled patient 1, 2 etc.

What I am trying to do is link the patient 'to do' section to the appropriate headed section in the cell/table row so that what I type in 'to do' appears in the equivelant section at the bottom.

This will give me a printable section (print pages X & Y) to create a job list for the oncoming shift and cut out the need to make written notes (and the errors this can create) and the need to print the whole document.

Please do experiment and let me know your thoughts

Attached Files

handover test a.doc (400.0 KB, 33 views)

Hi Steve
Perhaps a more easier option would be to use Excel. I have attached a very basic Mock Up of your document to show what can be done.
Page 1 contains the patient records and page 2 contains links to the To-Do box on the first page. Anything entered in the to-do box on the first page is automatically entered on the second page against the relevant patient.
Let me know if this is a potential solution for you and I would be happy to assist you further.
Good luck.
Tony(OTPM)

Attached Files

Ward Shift Handover List.xls (30.0 KB, 22 views)

This looks good so far. with the word doc I was working on the principal of telling staff, if its blue 'don't touch it', only alter the white areas. this shouldn't be too much of a problem in excel.

The first question I have is, Just how did you set it to duplicate in sheet 2? I assume what you set up is tied to the cell and not the sheet.

This is going to be displayed on a smart board and networked to a 50" plasma TV (used as a pc monitor) in another room. Is it possible to display this as a form/document, much as you see in print preview?

I need to keep the visual aspect as simple as possible as I have staff who could wipe the internet if it wasn't tightly controlled. Additional cells on view will confuse some of them and lead to document corruption and a headache for me.

I've had a bit of a play with the format, now how to format the front sheet similar in some way to the word document and additional tables below patient 1

Attached Files

Ward Shift Handover List-1b.xls (26.0 KB, 14 views)

Hi Steve
I will do a little more work on your updated Excel doc and we can speak again to agree where you need to be. I am happy to work with you to get to where you want to be.
Tony(OTPM)

Hi Steve
Here is where I am so far.
All BLUE cells are locked so users cannot change them.
The To-Do handover sheet is automatically updated by each individual patient record.
The To-Do handover sheet is totally locked so no one can change it.
I am just waiting for some help on the forum with a piece of vba code that automatically changes the cell height to adjust to the amount of text entered. This is because when you merge cells the auto row height does not work.
I will send the updated workbook as soon as I have that code.
Kind regards.
Tony(OTPM)

Hi Tony
This sounds even better, now once you get into visual basic, I'm lost. Maybe something I should learn, know any good resources I can learn from?

This is going onto a share point document library at some point and will be updated x3 daily, the previous being in an archive so I will have an evidence trail should something happen. Already got the access permissions sorted.

I very much appreciate the time that you and your friends are giving to this.