craigachan
09-30-2008, 03:07 PM
Does anyone know if there is an event that will run when there has not been activity (like mouse movement or keyboard activity) for a specific time? I use a timer to run a requery to update data on shared tables. However, it sometimes runs when I'm entering data and causes me to loose information that I'm putting in. Any ideas?
nIGHTmAYOR
09-30-2008, 04:13 PM
Well u can always use the Form's "On Key Press" property to reset your Requery timer (And thus buy you more time as you type) and remember to enable "Key Preview" property for form for such event to activate.
Also if that doesnt do it for you you can dig for resources on a windows api called "GetQueueStatus" which returns alot of usage behavior values of which "Idle Time" is one.
craigachan
09-30-2008, 04:36 PM
Thanks, I'll give it a try. Do you think this will slow things down?
nIGHTmAYOR
09-30-2008, 05:21 PM
Both techniques in nature wont slow things no , yet do note that useing timed requeries often annoy users (jet retrieve full tables then virtually construct the query which takes a moment of uncalled for pause within application - Hopefully you dont use small time intervals)