tkstock

There's probably a better way, but until you find it you can use this

Dim dtStart As Date

dtStart = Now

Do
Loop Until Now dtStart + TimeSerial(0, 0, 10)


--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"tkstock" wrote in message
...

I must apologize - I'm trying to use this in Access - I was hoping that
whatver worked for VBA in Excel would work for Access also, but I
didn't realize that the Application object for the wait method only
applied to Excel.

I don't suppose you would happen to know a method for Access?

Thanks!


--
tkstock
------------------------------------------------------------------------
tkstock's Profile:
http://www.excelforum.com/member.php...o&userid=14443
View this thread: http://www.excelforum.com/showthread...hreadid=264681