Search results

I am writing a process for a hospital application in the UK We have a concept of "Takes" which are periods to which patients coming into hospital are assigned to and thus the consultant (specialist) who looks after them. They are fixed times between 0800-2000 (Day take) and 2000-0800 (+1)...

Dear All, I have a report that contains several numeric fields for Blood tests. I am currently using the "TRIM" function to great success in the following format =Trim("Last Bloods: " & [dtmBloodsLast] & " Hb " & [intHb] etc..... However When I try to Bracket out any fields that do not...

Hi All, have a form frm_Inpatients with a command button that loads another form frm_PatientInfoSummary. I am trying to pass the primary key (or some other identifiable variable) from one form to another so that it load's the right info in the other form. My Globals are declared in a seperate...

Dear All, It’s been many months since I was last on the forum. I was wondering if I can get some help and education with regards to coding a search form. The database is a patient database used for tracking Inpatient data and Handover (or Handoffs for those in the US). It has been merrily...

Hi all, Struggling with quite a fundamental concept. I have designed a new structure to a database which I'm building for my hospital. (there's a graphic about half way down which sums it up) http://www.access-programmers.co.uk/forums/showthread.php?t=255708 Also direct...

Dear All, I am a doctor and I'm creating a new List system for my Orthopaedic (broken bones etc!) team in Hospital. The goal is to create a robust list system which can manage the emergenc and elective (planned) intake of patients of various consultants in one specialty. I'm rebuilding an...

Dear All, This is a query about Joins. Linking 3 tables one-to-many relationship query Can't get my head around this problem....It's pretty fundamental to the functioning of my database so I'd really appreciate some help. I'm trying to build a query that has a main table with data drawn from...

Hi all, My name is Seb I am a doctor in London just getting started with Access. I've not much background in programming but I am prepared to work hard through it! I'm "good with computers and stuff" and also have an extensive background in film and photography. I've been using tutorials on...