Recent content by jshooty

Keith--thanks for your response, and you were correct--there was a relationship problem. It was fixed with the assistance of some folks on another forum--it was a pretty simple fix, I think I had been staring at it too long to see it clearly anymore. Appreciate your offer to help!

If someone can help solve this for me, I would be forever grateful. I have attached the database to which I am referring for clarity. I am creating a database designed to input data for morbidity and mortality at my hospital. I have set up four main tables: tbldemographics (basic patient...

Neil--Good point, I see how that is going to get ugly. Going to use your suggestion to simplify the relationships. Thanks.

Dayna--I enjoyed your example, thanks for "out-morbidding" me. My database is designed to link the patient's current admission (with the current admission diagnoses) to the mortality event using a tab page. So even if a patient develops a new problem in the hospital from which they eventually...

Neil--Thanks for the input. I do have the diagnoses in a related table--the limit to seven diagnoses referred to the fact that I put seven comboboxes on the form into which the diagnoses from the related table are pulled. (I could add more--but that should hopefully be enough.) I am still...

On my main form, I have a number of comboboxes that I use to list patient diagnoses. These diagnoses are pulled from a table that lists the diagnoses with an autonumber primary key. On a subform where I am inputting data about a patient's death, I want to populate a "cause of death" combobox...

figured out the age dilemma I figured I wouldn't get many answers, since this has been posted many times in the past with various "solutions"--none of which in and of themselves seemed to suit my purposes. But between writing a little code of my own (a first) and cutting and pasting from...

I'm relatively new to access, and am trying to accomplish something that I think is relatively simple but, in my efforts, has lead to nothing but errors. What I am trying to do: I have a form in which I input dates for an event and a date of birth; from those two dates, I would like to generate...