Query that updates automatically on screen

  • Thread starter Thread starter BlueDigital
  • Start date Start date
B

BlueDigital

I have a database where students use a Form to sign in for computer help. I
would like to have a queue displayed on another screen that shows the
students what position they are in for help. How would I go about doing that?
I thought that having a query on a seperate screen (with no keyboard lol)
would be a good way of displaying the student's order, provided I can get a
query screen to update automatically or refresh say every 30 seconds. Is this
possible, or am I way off base?
 
One of the easiest way (for maintenance) is to display a web page on the
remove keyboard less site, and have a background process that ask IE (or
other) to refresh itself each 30 sec. against a static known url.
Maintenance wise, you have a barely minimum amount of custom made code
running at remote location (which are the most time expensive source to
re-initialize if an error occur, in general), which minimize installation
cost, and source of bugs. Sure, the server side has to generate those html
pages, but then, you have only one single PC to monitor (against failure).
If that PC is the only possible source of data modifications, it knows when
it is time to refresh the other html pages.


Vanderghast, Access MVP
 
BlueDigital said:
I have a database where students use a Form to sign in for computer help. I
would like to have a queue displayed on another screen that shows the
students what position they are in for help. How would I go about doing that?
I thought that having a query on a seperate screen (with no keyboard lol)
would be a good way of displaying the student's order, provided I can get a
query screen to update automatically or refresh say every 30 seconds. Is this
possible, or am I way off base?
Click to expand...


Use a datasheet or continuous form to display the queue.
you can then use the form's Timer event to requery the
form's data. Set the formes TimerInterval property to
something like once a minute (60000) or longer so it doesn't
overload the network.
 
Back
Top