Search results

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...

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...

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...

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...

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 +...

I have successfully managed to generate a Word document using automation from Access 2003. The next step is to be able to save the file in a manner and location that is appropriate for my needs. The documents are specific to individual patients and as such need to reflect this in their filenames...

Hi, I've recently joined and after my first question was answered in such a helpful way without being condascending to a newbie, i thought i would try my luck with a 2nd. I have a database in Access 2003 for use at my hospital in order to manage all my different clinics. It currently has 3...

Hi I'm a complete Access programming newbie. I have used Databases before but this is the first time of trying to do some really cool stuff. Essentially i'd like to merge Access field names into a Word document with bookmarks. I'm using Access and Word 2003. Eventually i'd like to attach this...