How to Use Timers to Run Actions or Code on an Interval in Microsoft Access

Поділитися
Вставка
  • Опубліковано 9 лис 2024

КОМЕНТАРІ • 9

  • @ManontheOutside
    @ManontheOutside Рік тому +2

    Thanks Sean, great video. I was looking for a timer control then realised there wasn't an actual control. :) Your video really helped me out, thanks!

    • @seanmackenziedataengineering
      @seanmackenziedataengineering  Рік тому +1

      Glad it helped! Yes they do belong on forms - this is generally great for most cases, though sometimes it would be cool to have a control, like you say!

  • @vwv5555
    @vwv5555 2 роки тому +1

    Smart feature 👍 Thanks a lot!

  • @artistryartistry7239
    @artistryartistry7239 2 роки тому +1

    Great video, thanks. So I'm curious about how the timer actually runs. If you had a variable, say, incrementing 1 to 10 in the form_timer procedure section, would it increment the entire counter to 10 almost instantaneously at the speed of the processor or does the code know to run at one cycle at a time, at the speed of the interval (say 1 second each) and so the whole thing would take 10 seconds? That's the issue I'm having. Even though the interval is set to 1000, it's finishing the counter instantaneously.

    • @artistryartistry7239
      @artistryartistry7239 2 роки тому +1

      Nevermind. For some reason a "do until" loop does not respect the timer, but an If statement does. So weird.

    • @seanmackenziedataengineering
      @seanmackenziedataengineering  2 роки тому

      Sounds like you got it figured! Timers can be a mind-bender.. especially when you have other events firing in your app in between timer events etc. The timer can be thrown off and not be exact due to these factors.

  • @interestingamerican3100
    @interestingamerican3100 2 роки тому +1

    OMG YAAAAAASSSSSSSS!!!!!!