Pausing in VBA 1

[russeldraper]

If there a function in VBA that allows you to pause the running of the program during runtime. For Example, the program's running and it hits a function pause(.5) that pauses the run for .5 seconds?

On a side note is there a website where I could find all of these function, like in Java there's the Java Sun website?

Thanks

 

[BillPower]

Hi russeldraper,

This is an API that I use. You need to paste it into the Declarations section of a Module:

Declare Sub Sleep Lib "kernel32.dll" (ByVal dwMilliseconds As Long)

To use it to pause for a second:

Sleep 1000

You can usually find almost anything about Access here at Tek-Tips. Just use the Search facility or ask.

Bill