Recent content by mrpwagner

Gemma, thanks for the input. I will consider redesigning my tables based on your input. Thank you. John, the query in the second database that you sent me is apparently dysfunctional and I could not open it but thanks for the effort.

As an emergency surgeon I anticipate re admissions. So I am planning a composite primary key composed from the medical record number, which will always stay the same, and the date of admission which should be unique. What are your thoughts on that?

I have downloaded this and studied this. I am still a bit unsure as to how to proceed. Do you have any suggestions? Do I need to copy everything into a VBA box? Keep in mind that I am a newbie and I am not used to a lot of this programing. Why is there an unbound box labeled text 13 in the...

I have spent MANY hours looking on the internet. reading two texts and just crunching to no avail. This is what I woud like to do. A bit of history. I have a table/form called Patient. Each patient has a medical record number (MRN) In this table the MRN is the priamary key (no other patient...

I am a newbie to access. I worked in the medical profession and am looking forward to using access to track my patient's and procedures that are performed, patients. I am looking forward to tracking which one of my colleagues are doing the procedures as well, as which the trainees that I am...