Create A Patient Database
I have started the tables for all the data and the main page for the form. I took a class 10yrs ago an I had beginner knowledge then an so I feel like newbie now.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I have been using the 'student' database from office.com as a template for how to save the dates (given that appointments and attendance are exactly the same!), however, even afterfollowing what has been set up in the 'student' template database, I can't seem to replicate it.
Every time I add multiple visit dates for a specific patient, these exact dates show up for every other patient in the database. I need to be able to add different dates for all the different patients.
One of the analyses is find out which encounter of the patient meets certain criteria and guidelines set out by this provincial authority. The analysis can be.of the total number of patients coming to this hospital, how many of them have evidence of a specific test in a given period. (say in the month of july and august)
So the calculation is patient-specific as you can see.
Now given that the database can actually store multiple encounters for each patient, how do I essentially base my calculation on each encounter rather than patient? I am told that each encounter needs to be looked at and we would like to find out if every encounter for that patient meets the criteria, etc.
How should I go about doing the analysis this way
3. I'm trying to create a patient database (think medical records)
Can I create a report for a single record (I.e., patient)? I would like to be able to create several single-record reports. For instance, one would be a kind of summary page withdemographics for this one particular patient, etc.
I've tried to create a macro that will use the "sendKeys" command to copy, then paste, the patient code in the field (field #1) for each record (stopping when reaching the next patient code).
It seems like this should be very doable, but I've been unsuccessful. There are many hundreds of labs (about 7 per patient), so I need to automate this.
1. Store patient identifying data (name, med record, date of birth, etc.)
2. Store multiple sets of vital signs for each patient
3. Show a patient record with:
- patient ID data
- All his/her vital signs data
1. Table: "tbl_patientData"
2. Table: "tbl_vitalsData" (linked to "tbl_patientData" by [medRec] field)
3. Form: frm_patientRecord with
a. Fields from "tbl_patientData"
b. Subform "frm_vitalsData subform" (linked to main form by [medRec])
I would like to use page numbers specific to the patient grouping--for each new patient the page numbers would restart with "1 of # pages."
Is there a way to do this that doesn't take master coding? I can do some coding but wouldn't know where to start.
What I'm trying to accomplish is to select a patient from a combo box, and then open a "New Admission" form using a command button, which will carry forward the Patient ID from the combo box and allow me to enter data for a new admission. Right now, the command button works to bring up the form with the existing admissions for that patient, but when I try to add a new record the Patient ID is lost within the form and it won't let me add any new records.
I'm obviously missing something, but I can't figure out what it is. If anyone is willing to help me out, I'd greatly appreciate it
I have created a Select Query that links to an ODBC table to pull patient demographic information from the electronic medical record system. The query pulls all of the data that I need correctly.
I have created a Form titled "Home". The "Home" Form has buttons that run different Macros. I want to be able to click one button on the "Home" Form to run the demographic query and search for a specific patient ID.
on click, I could enter the patient ID and it wouldsearch the linked ODBC connection for that patient's demographics and then automatically add that patient to the patient list table, along with of their demographic information that Ineed.
Like I said, I've been beating my head against the wall trying to figure this out and I just can't do it on my own.