Results 1 to 2 of 2

Thread: timer in Access

  1. #1
    Guest

    Post

    I want to start a process at a
    time selected...
    ie: i enter a time into a textbox,
    a timer function checks this,
    and waits until that time,
    and then kicks off my process...
    is there a way in Access?

  2. #2
    Addicted Member
    Join Date
    Jan 1999
    Posts
    165

    Post

    What you could do is set the Timer Interval on the form's properties Event Tab to some value to make it fire at the interval you want e.g. every minute.
    Then put the code into the On Timer event. This code first checks if Now (formatted to only output the time part) is greater than the time you specified - if it is then run the required code.

    Hope this helps.
    Regards,
    John.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width