Tabel refresh

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

Guest

Hi all,

I have a table which list the statuses of certain tasks. The database
updates the status field in the table to set it to appropriate statuses for
each task.

I am have written a query which extracts certains task names along with
their status updates. I would like to write a routine, sort of like a
"daemon" which constantly pulls the status of these tasks during business
hours.

The challenge I have is that I am not sure how I can update/ refresh the
query output while I have the query in table/grid view. Can you share your
thoughts and suggestions/ code snippets? Thank you in advance.

Ben


--
 
You could, assuming your database application is open all the time, use the
Timer object of a Form to "wake" the appropriate code to run your query, or
execute any other code you want to, for that matter.

Just remember the units for that timer are approximately millisecond units,
so 1000 would = 1 second.

Larry Linson
Microsoft Access MVP
 
Back
Top