Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - MedicineIntakeMonitor.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

>
Want a good read? Try The Summer of His Life (available on Amazon!)

MedicineIntakeMonitor.mdb

 Post Reply Post Reply
Author
Message
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: MedicineIntakeMonitor.mdb
    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/MedicineIntakeMonitor.zip

--

Email: adtejpal@gmail.com
Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

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