rusty.hammond at cpiqpc.com
rusty.hammond at cpiqpc.com
Wed Jul 9 13:27:29 CDT 2003
John, Instead of checking if it's within a window of time, how about checking if it's kickoff time has passed, then after running the process, have a table with a date field that you enter a new record into, with todays' date. Add code to your event that the first thing it checks is if there is a record in the dates table with the current date in it. If there is, skip the process, if not run it. This also adds a bit of logging for your process. Just something to think about, if not for this project (since you'll be rewriting it in vb.net), but maybe for another. Rusty -----Original Message----- From: John Colby [mailto:jcolby at colbyconsulting.com] Sent: Wednesday, July 09, 2003 12:47 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Clock Control Drew, Does it have an "alarm" which raises an event, and will it drop onto a form (or can I instantiate it as a class)? I am trying to do some data processing at a given time every weekday. Yes, I can (and presently do) do this with a form and it's timer, however that is an ugly solution and I would like to do better. I will eventually port the whole thing to vb.net but in the meantime I want to replace my current "check the timer every X ticks to see if it's within a window of time" nonsense with a "tell me when it's time to do this" method. John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Drew Wutka Sent: Wednesday, July 09, 2003 11:38 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Clock Control I have one that's ActiveX (It's on planetsourcecode.com, search for Enigma in the VB Section, you'll find my Enigma Encryption project. Then search for all submissions by me, and you'll find my 'clock' ActiveX control. Drew -----Original Message----- From: John Colby [mailto:jcolby at colbyconsulting.com] Sent: Wednesday, July 09, 2003 10:24 AM To: AccessD Subject: [AccessD] Clock Control Does anyone know of a free clock control that can be dropped onto a form and which fires an event at a given time? John W. Colby www.colbyconsulting.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