Search results

Overall at this stage I'm feeling a bit overwhelemed with the scale of the task i've set myself!! ....

Dear Pat, Many thanks again for your detailed response. Sorry for my delayed reply I was working nights this weekend (including the extra hour when the clocks went back!) In a hospital situation, I'm going to guess that the same computer is used by multiple people. If your procedure is to...

Dear Pat, I've good deal of work on the database to try and incoporate your suggestions. Very helpful. I've tried to respond paragraph by paragraph.... I would add dates and possibly even date/time to the "tests" tables. There will be multiple tests over time and although you can order them...

I've done some Extensive work on the design Would be grateful for feedback!

Dear Pat, Many thanks for your very helpful comments and encouragement! I've spent quite a few hundreds of hours in the last year trying to get my head around Access and database design in general... If you believe it the majority of medical teams use Word-based hand and assistance which...

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

Many thanks plog Never found the answer to the original form issue....but creating a new form solved the problem.... Case closed on this one.

Hi Plog, Thanks again. Switching the source to the tblMainTable allows data entry but on reloading the form shows no records. This data is assigned to the tblMainTable however.... Your solution avoids using the query above.... presumably I can use the Query to drive reports later? Is there...

Thanks for your quick reply! I can't believe I missed this! Assiging the proper values pulls the data as you've rightly pointed out. I thought that I'd checked that... However.... I now have a new issue that seems to have arisen. If I leave the Joins as Inner Joins I am unable to add any new...

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