I enjoyed seeing your sleep function video recently and it works well the way you used it but I am having a problem pausing between functions. The basic example below should; Change detail back colour and beep then 1 second later change the Header Color , Bleep and 1 second later change the footer color.
But instead it Bleeps then 1 second later Bleeps again and then the back color, Header color and Footer color all change at the same time, so it looks like the code isn't reading in the correct order.
Can this sort of pause be done please?? and why does it read the code in the wrong order?
You need to throw a DoEvents in there so that Access can "do stuff" like update the screen. Put one before each of your Sleep statements.
Tim HaleOP
@Reply
2 years ago
Thank you for your quick reply yes that fixed my example problem and it will fix my actual database. Richard, Thank you for the great job you are doing, your videos are great.
Sami Shamma
@Reply 2 years ago
Hi Tim
I was like you, looking from the outside into Richard's world.
My becoming a member was the best thing I have ever done to improve my skills.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
