Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010
    Orange County, CA

    Unanswered: How long until the timer event triggers?

    I have a timer event set to run every 12 hours (43200000 ms). Does anyone know how to query/poll the timer object? I want to know how long until the timer event will trigger again.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    a 12 hour trigger? sounds an odd request

    what you could do is take note of the time the trigger went, add twelve hours to it (using say the dateadd function) and then subtract the current time (use now()) from that calculated time and that will give you the result which can be displayed using a format() function using an appropriate time mask.

    just wndering out aloud if you woudl be better off using an autoexec or specified macro called on a windows scheduler event rather than a timer within Access
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

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