From: John W. Vinson on 24 Apr 2010 13:33
On Sat, 24 Apr 2010 04:40:01 -0700, Karren Lorr
>Is there a way to run a set of codes every 15 mins.
>Private Sub FormButton_Click()
>Do something here
>wait 15 mins and then repeat the Do something here
Open the form in design view and choose the Timer event. Edit your "do
something" code into that event.
Your form button would just set the form's Timer property to 15 minutes, in
milliseconds. Your click code could be:
Private Sub Form_Button_Click()
Me.Timer = 1000*60*15
Call Timer ' to have it "do something" the first time
You'll need some way to turn it off (by just setting the form's Timer property
John W. Vinson [MVP]