Hey all, first time here.
I have a database that is designed to be opened and viewed at other locations on the network.
I use Form (A) to modify Data in Table (A), and Form (B) is used scrictly to view.
Now It works great and updates every 10 seconds with a form.requery on a timer event.
Now This display is to give Scheduled and Actual times. As times are posted, I use Conditional formatting to change the colors reflecting on time, due soon, or late.
However, my problem is if the Computer is left alone, eventually the computer will stop (seems to be random) adjusting the colors as I requested. As soon as you hover the mouse over the form (Access Window), it will then wake back up and adjust the colors again.
However I wish to not use form.requery only because i want the window to not slide back up to the top of the list every time.
Any Suggestions?
|