Print Page | Close Window


Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
Printed Date: 26 Jan 2021 at 7:19pm
Software Version: Web Wiz Forums 12.03 -

Topic: MedicineIntakeMonitor.mdb
Posted By: A.D. Tejpal
Subject: MedicineIntakeMonitor.mdb
Date Posted: 08 Jul 2008 at 10:29pm
    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: - uploads/37/


Email: -

Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 -
Copyright ©2001-2019 Web Wiz Ltd. -