Dear Experts,
Access 2002 w/SP3
Access 2003 w/SP2
Windows XP Pro w/SP2
The API: Shell and Wait, by Terry Kreft is not working to me
http://www.mvps.org/access/api/api0004.htmI know I can not post the API by Terry Kreft, but I can post what changes I did in the original API
------
Function ShellWait(Pathname As String, Optional WindowStyle As Long)
End Function
-----
This is my code in a module
'Initialize New Event Make_Access_Wait
'Make Access wait till It is done with other application
MsgBox "Rutina ShellWait"
Call ShellWait("C:\Program Files\Dups\Batch Files\HashIt.bat")
I really need to Access wait till I'm done with my other application. But due is not working I had to add another API
API: Make code go to Sleep by by Dev Ashish
http://www.mvps.org/access/api/api0021.htm'Implement a wait period in Access where the duration can be
'increased/decreased bychanging the constant to a corressponding higher/lower value
MsgBox "Rutina sSleep"
Call sSleep(9000)
This API is working fine, the problem is the code does a hash in different directories, some of them with a lot of files to hash, others with a few
In this way if the user selects a directory with few files to hash the user has to wait 9000 milliseconds. In other hands if the user selects a directory with a lot of files also he has to wait the same time, but some directories could take more than 1 hour to complete the entire process
I don not want to use the API: Make code go to Sleep by Dev Ashish for this reason, and I do know what I its wrong with the API by Terry Kreft or why is not working for my code
I first want to know why the API by Terry Kreft is not working for me, and if there is another alternative to make Access wait till the entire process ends.
Thanks in advance for any help
Regards,
Antonio Macias
Start Free Trial
