Postpone the execution time of command

[Deleted member 162737]

Regards to all,

I have problem... I would like to postpone the execution time of command.

I have two pictures, one above the other. I want, when I move the mouse over the upper one, to display the lower one and that should last 5 seconds if mouse is not moving. After that time the first image should be displayed again.

Thanks in advance!

 

[The_Doc_Man]

If you don't want anything else to happen, then either a SLEEP or an APPLICATION.WAIT command might do what you want. Remember, NOTHING ELSE will happen in your Access app if you use the sleep option.

VBA Sleep vs VBA Wait - Pause or Delay code execution in Excel VBA

How to use the VBA Sleep function and how to use the VBA Wait function. Pause VBA Code Execution. VBA Sleep vs VBA Wait vs VBA DoEvents

analystcave.com

The article includes a discussion of the pros and cons of each approach. Both are simple. Both can have the effect you want, though in different ways. I have used the SLEEP method for short delays a few times, such as a limited "blink" option by having several very short sleeps in a row while alternating colors on something that I didn't want interrupted. The trick would be "if the mouse is not moving" and that might force you to use the "wait" option. Read the article and see which is better.