Easy Points: Hospital DB Alerts.
Posted on 2005-03-17
I need help with my homework.
I created an Access DB for a hospital, with one table containing a list of patients and their personal and medical data. One of the columns stores the date for the next programmed medical appointment for each one of the patients.
ID Name Next Appointment
5550804 John Doe 3/27/2004
What I need is, when the DB is open I should be advised if there is any appointments programmed for today or tomorrow. Simple as that.
I'm not much experienced in MS Access, but I know a lot about programming for Excel (VBA) so that might be a help. I need a hint about what would be the best way of having those alerts working.
Thanks in advance.