Event Reminder in Access for Office XP PLEASE HELP

  • Thread starter Thread starter mr_mojo_risin77
  • Start date Start date
M

mr_mojo_risin77

I am desperate for help on this, this problem has been driving m
insane. I am using access from office xp to store information abou
members of a club/newsletter such as names, birthdays, phone numbers
etc. My problem is that I need to find a way (if possible) to ge
access to give an alert of some kind (like a pop-up?) when it i
someone's birthday or it is time to collect their dues. Is thi
possible in access, and if so, could someone help me? Thanks fo
reading
 
There is nothing built-in to Access to do this. It is certainly possible for
someone with a working knowledge of VBA and SQL to develop an Access
application to do it. You could create a form based on a query that selects
records with dates in the appropriate range, and requery the form using the
form's Timer event procedure.

For example, to list people with birthdays today the form's record source
might look something like ...

SELECT * FROM YourTable WHERE Month([YourDateOfBirthField]) = Month(Date())
AND Day([YourDateOfBirthField]) = Day(Date())

The Timer event procedure would include the line ...

Me.Requery

Set the form's Timer Interval property to an appropriate interval. It's
measured in thousand's of a second, so to requery the form say, once a
minute, set the Timer Interval property to 60000.
 
Back
Top