John W. Colby
jwcolby at colbyconsulting.com
Tue Dec 28 15:43:41 CST 2004
Robert, My timer class allows TIMING how long something runs, not firing a process. Something you said though sure makes me wonder. Would it be possible to have an MDB that is linked to the database needing a process fired. That external mdb has a form timer running which fires every N seconds or whatever. It calls a function in the MDB being controlled. I suspect that the real issue is the single threaded nature of VB not liking being interrupted inside certain types of operations such as a function called in a query for example. It really probably won't matter whether the function is interrupted by a form timer inside the same database or a timer in a form in an external database. It would certainly be good to check out though. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert Gracie Sent: Tuesday, December 28, 2004 4:30 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Form Timer Alternitive Thank You John, I will check it out... Robert Gracie -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Bartow Sent: Tuesday, December 28, 2004 11:15 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Form Timer Alternitive JC's Timer class sample on his website should be a good starting point. Www.colbyconsulting.com HTH John B. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Tuesday, December 28, 2004 9:26 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Form Timer Alternitive Robert, I use a form timer to see if the System Administrator wants to force all users to log off. The form timer opens a recordset once per minute to see if a flag has been set in a small table in the BE. This has worked fine for years. The form timer itself does not try to keep track of the elapsed time. Suggestions: Put a small table into the FE to capture a time. At certain key events run a recordset to update that time. Have a form timer run once per minute(?) to see if you have exceeded your elapsed time - then take the action you need to take. You could also use a form timer in a referenced mde or mdb to look up the elapsed time in the FE table. But, the referenced mde or mdb cannot call a procedure or function in the referencing mdb or mde. HTH, Dan Waters -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert Gracie Sent: Tuesday, December 28, 2004 9:09 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Form Timer Alternitive Hello All, Has anyone come up with an alternative to using a form timer? I have great need now to come up with a solution for monitoring inactivity. Access form timers, used in a complex program, seems to reek havoc, and creates a wide variety of anomalies. So I need to come up with an alternative. Does anyone know if these possible solution would work? Solution 1 Create a form timer class in a referenced MDE that will raise events that I can grab in the front .mdb. What I'm not sure is if the timer class code can monitor activity in the .mdb. The other question is if this form timer is going to cause the same anomalies. Solution 2 Using the same basic idea as above, but with a completely separate mde (un-referenced) to monitor activity in the mdb in question. Solution 3 Using Windows API's (Have no clue about this one) for the timer & monitoring. The only thing I do know for sure is, I simply cannot have a form timer running inside of the same mdb. Any idea's? Robert Gracie -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com