Search results

Almost, there is one patient who would have multiple Admissions and each Admission might have multiple Attendances to Hospital. Awkward terminology I know, but I wanted to closely map the terminology of the main Hospital where Admissions have lots of little ‘episodes’ called Attendances hanging...

Thanks for the help Pat. Would this then not require the Many to Many relationships that'd so doing my head in?.. I suspect not but I thought I'd cross my fingers. How would you select one patient on the left and then show the Admissions on the right where one could then also be selected and...

Thank for this Mark, I had to put it down for a week or so to preserve my sanity! I think I've managed it now... not sure how I managed it... but I did nonetheless. :D

That’s great thanks. I think I missed a step and had gone with an Attendance subform on the Admissions form only. I constantly scratch my head with relationships TBH, what do you suggest would be the most efficient? Thanks for your help

Hope someone can help, I've sweated over this all day. I have 3 tables, Demographics, Admissions and Attendances. Patient's records are stored in Demographics (obvs) and each can have more than one Admission and numerous Attendances within those Admissions. I'd like to be able to represent...

Thank you, arnelgp for your help on this. For those that are interested, I thought I would post my solution once I figured it out. It turned out the issue was that the field name was the same (CRT_UN) across all the subforms on the mainform. Once I changed the one I wanted, to something unique...

Unfortunately that came back with an error. I took a screen dump of it for information, what are your thoughts?

Thanks for your reply, I think I kinda follow. This is what I did, but it only partially works. CURRENT_CRT_QUERY_FORM's record source is now CURRENT_CRT_QUERY with the criteria: [Forms]![PROCEDURE_DAY_PLANNER_DATASHEET_FORM]![CRT_UN] On the double click event on the subform...

Hi, I hope someone can help, as I find myself at an impasse. My database has two tables, UN is the PK for one (CRT_demographics) and it is related to the same entry in a second table (simply called CRT) with a field name CRT_UN. Now, I have a form called list_planner in which is a subform...

I kinda answered my own question above by adding a subform onto Clinic2, however i find these things are never as simple as that! I normally use this code to populate bookmarks in word documents using the contents of the forms. What needs to change in this code in order to get the contents of...

Oh cool, can i add all available tables?

Hi, hope someone can help on this. I have 3 tables; demographics, clinic1 and clinic2. If i just open the table i can view all the clinics associated with different patients (with a little + sign in the left) However if i query the same table and enter a criteria that prompts for a hospital...

Thanks again for your time on this. I wanted to reference a bookmark, change it's content, then reinstate the bookmark in order to reference it later in the code for use in the the filename. The end result of the code for example (when working properly) is a filename...

Many thanks for your response I tried: objWord.Quit Set objWord = Nothing The same thing happened, i don't think the issue lies here. I think the issue lies with either re-inserting the bookmark and referencing it in the filename or re-using 'DCCVUN' and/or 'DCCVCASENUMBER' -both of which are...

Thanks for your reply I think i successfully quit the word instance. It still didn't help. I think the error occurs as i try to re-bookmark the fields in order to use those fields in the filename using: .ActiveDocument.Bookmarks.Add Name:="DCCVCASENUMBER", Range:=Selection.Range and...

Just to clarify; when i attempt to repeat the event; the document opens OK but hangs on 'DCCVUN' and will not complete. I have to close the Word document without saving it, close the DB, restart and redo the event... this time it works great. Look forward to hearing from someone

hi I've got this code working just the way i want (with help from some clever guys on here). There is one tiny issue however, whenever i run it and it completes successfully; i'm unable to repeat it without first having to close the DB. Can anyone see anything i should add (or take away)? If...

Great thanks Pat, that solved my problem.

Fab thank you; you've saved my bacon!!

Hi I'm currently using: Dim pStr As String pStr = "S:\ChestPain\Elective Cardioversion\Correspondence\" pStr = pStr + ActiveDocument.Bookmarks("DCCVUN").Range.Text pStr = pStr + "-" pStr = pStr + ActiveDocument.Bookmarks("CASE").Range.Text pStr = pStr +...