Pause Code Execution

[Guest]

I am using Access 2003 and an activex tool that allows me to get data from
the serial port which is hooked to a scale. I need to get multiple readings
from the scale over a period of time to perform a measurement. I have the
code working great to get the data from the port and into the database but
what I am having trouble with is a pause function to wait 1 second between
readings. I have been using this code to make the computer wait, but with
different speed processors this will not work well.
For i = 1 To 10000000
Next i
Can anyone tell me the syntax or function to make the computer pause 1
second during code operation?

Thanks!

 

[Jeff Boyce]

I believe you can find an API-based "sleep" command at the mvps.org/access
website, under the API section.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Douglas J. Steele]

Specifically,http://www.mvps.org/access/api/api0021.htm

Another option, if using a form, is to use the Form's Timer.