freelanceprogrammers.org Forum Index » Visual Basic
Creating an alarm Procedure
Joined: 20 Apr 2005
Posts: 6
Creating an alarm Procedure
Guys,
I am not sure how to construct this procedure. I have a database with a
field call alarm time, which holds the time an alarm should be fired. What`s
the best way to write the alarm?
I am thinking of writing a loop that keeps checking the time and based on if
statements, it would check the time more frequently as the time approaches.
However, I run into a problem using this method.
1. I might have more than one appointment scheduled on the same day with
alarms turned on for each one. How do I accommodate all appointments?
Obviously I cannot create a loop per appointment. Any ideas?
2. If I go by the idea mentioned above of using a loop and keep checking the
time, am I killing my computer`s resources? This is very new to me and I
have never experienced it anywhere. So any help is tremendously appreciated.
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.10.4 - Release Date: 4/27/2005
[Non-text portions of this message have been removed]
Joined: 06 Apr 2005
Posts: 3
Creating an alarm Procedure
It`s funny that I happened to be reading this now. I`m preparing to
present some software that I wrote that does this very thing. I
have my program set to be launched every hour in Task Scheduler.
When it runs it check to see if the time has passed for any events.
If the time is up or is passed, it checks a second table to see if
that event has been responded to. If it has not been responded to,
then it presents an alarm with a message that describes it. When
the user responds to it, it records the response in the second table
I mentioned.
Hope this helps,
Mike
--- In VBBeginners@yahoogroups.com, "Jean-Pierre Jamous"
<jpjamous@n...> wrote:
> Guys,
>
> I am not sure how to construct this procedure. I have a database
with a
> field call alarm time, which holds the time an alarm should be
fired. What`s
> the best way to write the alarm?
>
> I am thinking of writing a loop that keeps checking the time and
based on if
> statements, it would check the time more frequently as the time
approaches.
> However, I run into a problem using this method.
>
> 1. I might have more than one appointment scheduled on the same
day with
> alarms turned on for each one. How do I accommodate all
appointments?
> Obviously I cannot create a loop per appointment. Any ideas?
>
> 2. If I go by the idea mentioned above of using a loop and keep
checking the
> time, am I killing my computer`s resources? This is very new to me
and I
> have never experienced it anywhere. So any help is tremendously
appreciated.
>
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.10.4 - Release Date:
4/27/2005
>
>
>
> [Non-text portions of this message have been removed]
All times are GMT
Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Freelace Website Designer - Customer web design and software building.
Booking Calendar - reservation calendar script
Land Surveying - total station instruments and equipments
China Wholesale - Electronics Products
Character Studio - Tutorials and Help
Booking Calendar - reservation calendar script
Land Surveying - total station instruments and equipments
China Wholesale - Electronics Products
Character Studio - Tutorials and Help