Auto Refreshing Form? (1 Viewer)

[KevlarKev]

Hello Access Legends!

One of the directors of the company I work for would like to have a large screen display the current status of jobs that my database stores. To cut a long story short the table he is interested in is called tblJobsLogging and is updated manually by our laboratory on a regular basis as jobs are completed using a form linked to a query in turn linked to that table.

Think fast food chain order monitor. He wants to be able to look up from his desk and see the progress directly in front of him at any point.

Is there any way that I can have an access form displaying these records in a datasheet view which continuously refreshes every X seconds / minutes or updates as a record is updated in the underlying table?

Thoughts and solutions very much appreciated.

Kev.

 

[Minty]

Yes - create the form with the data you need on it.
Set the OnTimer Event to the following code:

Private Sub Form_Timer()

Me.Requery

End Sub

Then set the forms Timer Interval to the number of milliseconds between refreshes (60000 is a minute)

 

[pbaldy]

One way is to Requery the form in its timer event, on the desired interval.