New To Access:Don't Know How to Create a Tickler System

[Guest]

Hello,
I have a database of patients that would fit well with a pop-up tickler
system (I think that is what it's called). There is over 50 patients and they
are all on the same system meaning that once they are "enrolled" they are
called 2 weeks from that date, meet with 5 months from that date, and
reinterviewed again 7 months (these are just examples as I actually have 9
different events that each patient goes through). Each patient has the same
exact timetable, and it would be very cool if some helpful and good person
could explain to me how I can convert my preexisting database into a
mechanical query or something that basically pops up (it's okay if I have to
open something to check for it). It boils down to the need for simplicity;
that I would like to see (in some sort of screen) who needs what done today
(example being on this date J. Smith has a phone call interview due,
W.Barclift has an interview due, and J.Durham has her 7 month reinterview due
today).
I have just learned about Access about a week ago and have no clue how I
would begin to build such a complicated program and I would greatly
appreciate any tips, or advice anybody can give.
Thanks!

 

[Guest]

I should also add that the patients have varying start dates but with the
same intervals from that point on.

 

[Guest]

And one more thing (this is getting ridiculous I know), at our company we
have the entire Microsoft Office 2003 package with some updates too...just in
case there is another program that this kind of thing would be easier with
(as long as we can transfer the database from Access).

 

[Tony Toews [MVP]]

I have a database of patients that would fit well with a pop-up tickler
system (I think that is what it's called). There is over 50 patients and they
are all on the same system meaning that once they are "enrolled" they are
called 2 weeks from that date, meet with 5 months from that date, and
reinterviewed again 7 months (these are just examples as I actually have 9
different events that each patient goes through). Each patient has the same
exact timetable, and it would be very cool if some helpful and good person
could explain to me how I can convert my preexisting database into a
mechanical query or something that basically pops up (it's okay if I have to
open something to check for it).

Create a query which looks at the tickler date based on todays date.
I.e. <= Date(). Also use a check box which indicates that the call or
interview has happened so they no longer appear on your list. And put
that field in the criteria of your query.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm