Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 12th, 2003, 04:46 PM
Authorized User
 
Join Date: Oct 2003
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default Is There A Timer Object One Could Use In Access

Hi, All!

I'm just a little past my Advance Access class from a local community college. I'm good enough to tutor those in Access and Advance Access class. The problem is I don't know it all!

I have no problem helping a student who has the same instructor I had, but when they have a part-time instructor at night who goes off the trail, that is another story.

My question is: Is there a Timer object that I can use when a user clicks a command button named "SNOOZE". One that can be set to pop a form up again 10+ minutes later.

Thanks in advance,

Bob
vbprogwb

 
Old November 12th, 2003, 05:15 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

There is a timer event for forms. You can set the interval as needed for the timer to re-set itself(I forget what the incremental value is). You can do something every N seconds with that timer. I use it to increment a progress bar on my splash forms. What you can do is hide your form and every 10 minutes requery the database and if something is found, show itself with a prompt.

It is a cool event to play with.



Sal





Similar Threads
Thread Thread Starter Forum Replies Last Post
cannot access to com+ object gabrieldcr2 ASP.NET 1.0 and 1.1 Professional 0 March 6th, 2008 03:08 PM
access class object Sheraz Khan ASP.NET 2.0 Professional 0 September 10th, 2007 06:19 PM
Access Object Dependencies apologia315 Access 0 July 31st, 2006 12:37 PM
No ambient object in access? ParadiseIsle Access 1 November 21st, 2005 09:57 AM
To access "EXCEL" object mcinar Classic ASP Basics 7 November 30th, 2004 12:44 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.