Polling?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I need to make a program which polls every so many seconds if there are new
messages in a table.
Anyone to gice me a hint?

Thanks

Mike G
 
You can do this in Access with a form's OnTimer event. Set the Timer
Interval to 10000, for example, to run every 10 seconds. You could add a
field to the form to store the number of records in the table and if the
number changes, do something. The number of records in a table can be
determined by using the function DCount(). Then, you'd have the form
automatically open whenever the database is opened and the form would remain
active until you closed it.
 
Thanks!

I'll give it a try.

Mike


kingston via AccessMonster.com said:
You can do this in Access with a form's OnTimer event. Set the Timer
Interval to 10000, for example, to run every 10 seconds. You could add a
field to the form to store the number of records in the table and if the
number changes, do something. The number of records in a table can be
determined by using the function DCount(). Then, you'd have the form
automatically open whenever the database is opened and the form would remain
active until you closed it.
Click to expand...
 
Back
Top