Automatically run "something" when the system time match time in t

  • Thread starter Thread starter ali
  • Start date Start date
A

ali

I have a Table, which i save different time slots
eg:
Time Remark

10:30:00 am
10:45:00 am
10:59:00 am
11:43:00 am
---------------------------------------------------------------------------------------
I want to:

Write a VB code, when the system time matches the time in my table, then "do
something".





Allen Phailat Wongakanit
 
Hi,
you can setup some form timer event to tick every, say 5 mins, then in timer
event check the current time against time slot in table:

if dcount("*", "MyTable","abs(datediff('n',[Time], TimeValue(Now())))<5")>0
then
'do something
end if

something like this


--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 
Back
Top