Hi,
Delaying milliseconds is a topic has been beat to death just about everywhere, especially in Excel. And despite that, i've never come across a single piece of code that is able to delay time in MS Access for less than a second.
I've used Win APIs and a host of other functions without any success. But i'm beginning to questions if the delay is actually occurring but "screen updating" is not occurring?
Usually when someone wants to delay time in MS Access or Excel, they are trying to execute a lousy animation (which is quite fun).
Assume the following example, where we also assume "DelayMS" is a function for delaying milliseconds...
Code:Private sub animate() Dim i as integer For i = 1 to 100000 textbox1.left = textbox1.left + i DelayMS(200) '200 millisecond Next i End sub
So my questions are...
1.) Will the above be able to "animate" this textbox? Or is there a missing element - additional piece of code to update screen, etc.
2.) Are millisecond delays possible, if so, do you have a proven working function you'd be willing to offer?
Thanks for your time.