Use the DoEvents Command to Yield Execution to Other Processes During Loops in Microsoft Access

[@Shadow.Dragon]

Thanks for the video! I really liked the use of "Mod" to not display every "print" item.

[@alanhill769]

I came across this problem when I was scanning several folders on different hard drives to add videos into my database. I used SysCmd acSysCmdSetStatus I got a progress update in the bottom left hand side telling me how far the drive scan had progressed. But I do like DoEvents I am going to play with it. I do think the screen is a better place to display information. There always appears to be an easier way to do stuff in Access. I have found Richard Rost often has the simplest solutions. In fact Microsoft is probably the last place to look to solve your problems. There is always an easier way. Thank you.

[@599CD]

Microsoft's website has a lot of great technical information but not a lot of how to. Which is okay because that's where I come in. LOL. I liken Microsoft's website to a reference book that's not necessarily great for learning something but good for looking something up once you kind of already sort of know how to do it.

[@alanhill769]

@@599CD That reminds me of when I was a kid. If i could not spell a word, how could I find it in the dictionary? You have to know how the word is spelt to find it. Then you don't need a dictionary do you? Unless you need to find out what the word means. A bit like my programming. I have several routines some I do not understand exactly how they work but they do. That's good enough for me. I think people use words and they have no idea what they mean but they use them anyway. Have a great day.

[@nickbroekhuizen8858]

Thanks, Richard, I've learned something new ... thanks. :)

[@599CD]

You're very welcome

[@GlobusMark]

That’s even better then the calculator! 😊 Thank you! Great video! 👍

[@599CD]

You're very welcome

[@torstenkrumel6970]

Very helpful ❤

[@599CD]

Thanks

[@saneneweyes6189]

It's not exactly related to this video (what with the DoEvent function), but it made me want to put an abort function for a subroutine (and a series of related subroutines, toggled by checkboxes, within the main subroutine) utilizing a long series of followhyperlink / sendkeys / sleep functions to perform searches in a nuymber of online repositories. The aim is to help minimize some of the redundant tasks for my end users.

[@599CD]

Yeah I put abort buttons near anything that runs in Loops or has lots of steps

[@Stache987]

I'd suggest a on screen display updated every 20 seconds or so displaying the time so a user knows the process is moving

[@599CD]

Yep you could indeed use time as a counter variable in fact someone else already asked me how to do this a little while back and it's on my list for a video so stay tuned

[@Stache987]

The doggy doorman works for free BTW

[@599CD]

He gets paid in treats.

[@Stache987]

@@599CD our pets treats are called "candy" to them, as for human food, they get dibs on cleaning the dishes first