Timer!!!

[MagMil]

I need help, how to input alarm in my access database?

I have data that should be insert over and over in 4 hours duration, when I put first data, I get local time and I need timer that could count 4 hours and after to make notification (massage) that the time for the Product of the database are over and need to input clean Product.

something like in first-->
ProductTime is column from Access Database
i=j=ProductTime;
for (i=0;i>= j+4hours, i++)
{
If(i=j+4h)
{
msgbox("ALARM- TIME is OVER");
}
}

Can someone please help me , I'm still new in VBA

thanks in advanced

 

[rsj78]

Hi.
Try using build-in access form timer.

Check out form properties, find something like "On Timer".
Pick there "Event procedure".
Write there a macro that you want to autorun after xxxx mins/hours.
In the field "Time Interval" set the time, after which macro should run.
As i remember Time Interval is in milisec, so you need to recalc 4h into ms.

Hope it will help.

Sorry for my english, it isn't quite excelent