This sample db demonstrates monitoring of actual intake by patients against the
course of various medicines prescribed by respective doctors.
For a given patient, the subform at top displays the medicine courses as
prescribed by the doctors. It includes the name of medicine, name of doctor, date
of prescription, duration (days) and doses (number of times per day). There is a field
for doctor's notes as well.
The other subform displays a grid of shadow new records for each dose on each
day of the prescribed course for each medicine. To confirm intake of a particular
dose of given medicine, the user clicks in a check box named Done. The date and
time for such confirmation gets automatically inserted in field named DtStamp.
As soon as the user clicks the Done check box, the current shadow record gets
converted into an actual record in table T_MedTrack. This way, there is no
redundant addition to records, till confirmatory action is actually implemented. Also,
if the user attempts to click the check box for any of the future dates (i.e. beyond
today's date), a friendly message preventing such an entry comes up.
As added convenience, highlighting has been provided as follows:
(a) When the user is on any record in the compliance subform (the lower one),
corresponding record in prescription subform (the upper one) gets highlighted
in yellow. This way, the user can readily see the doctor's and other particulars
relevant to the current dose of current medicine.
(b) When compliance for a given dose is confirmed and the date stamp matches
due date, the record gets highlighted in light blue if the due date is same as
today's date. Later, when this due date becomes older than current day's
date, the highlight color for such a record changes to orange.
(c) Records where compliance date stamp does not match the due date, are
highlighted in pink.
(d) Records older than current day's date, where compliance has not been
confirmed (via selection of check box), are also highlighted in pink.
The sample includes report generation for the selected settings, providing
compliance status for various prescriptions. Records where compliance is missing
or delayed beyond due date, are highlighted in color. Summary of the incidence of
missed or delayed compliance is given in the group footer.
Version: Access 2K/XP/2K3/2K7 (Access 2000 File Format) Download Access 2K/XP/2K3/2K7: http://www.rogersaccesslibrary.com/forum/uploads/37/MedicineIntakeMonitor.zip - uploads/37/MedicineIntakeMonitor.zip
------------- --
Email: mailto:adtejpal@gmail.com - adtejpal@gmail.com
|