Checking for time intervals

  • Thread starter Thread starter David Chase
  • Start date Start date
D

David Chase

I have an application where the user wants to be able to enter "To Do" lists
and have them be reminded when a time comes up that day, much like those in
Outlook. They want an Access-only solution as many users do not have
Outlook open and they also want the "To Do" records stored and linked to
customers in their SQL Server database (Access 2000 front-end). Can anyone
direct me as to where to look or how to accomplish this? Thanks.

David
 
Assuming you have already created a table to hold the reminders, with a
date/time field for the reminder time, you need to run code to check
peridocially to check whether there are any due. To do that, use the Timer
event of a hidden form that is always open.
 
David,

From experience, I found this really hard to do using Access itself. The
reason being that users would only get reminded when Access was open. In
fact, I used the Timer event for a form and the form itself had to be open
all the time which i found to be a pain in the backside while trying to use
a computer. The problem was checking to see if anything needed to be
displayed even if access wasn't open. My solution was to create a very
simple program in Visual Basic itself and get the program to start up and
sit in the system tray checking for data periodically. If any data was found
then it would ask the user if they want to view the data (either using a
form in the program or by opening Access and doing it that way). The only
problem with this was that I never found a secure way of doing this. I had
to store the user name and password in order to connect through code. Not a
secure way to do it at all! Luckily, security wasn't a problem in my case
and I also have VB6 and VB.Net - which also came in handy :-).

Hope u can figure out a solution, but it definatly wasn't plain sailing for
me...

Neil.
 
Back
Top