Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Application.Wait

Discussion in 'Information Technology' started by JON JON, Jul 28, 2006.

  1. JON JON

    JON JON
    Expand Collapse
    Guest

    Hello NG,

    Is the Wait Method not supported in Access? Any workaround? Please note
    that I can not use the onTimer event since I will be using the method within
    a loop code somewhat like:

    For i = 1 to 10
    'my code here
    Application.Wait Now() + Timeserial (0,0,1)
    next i

    TIA
     
  2. Graham R Seach

    Graham R Seach
    Expand Collapse
    Guest

    Jon,

    Public Declare Sub Sleep Lib "kernel32" Alias "Sleep" (ByVal dwMilliseconds
    As Long)

    Then somewhere in your code:
    Sleep 1000 ' =1 second (1000 milliseconds)

    Regards,
    Graham R Seach
    Microsoft Access MVP
    Canberra, Australia
    ---------------------------

    "JON JON" <conrado_capistranoREMOVE@msn.com> wrote in message
    news:OBS9wROeGHA.1264@TK2MSFTNGP05.phx.gbl...
    > Hello NG,
    >
    > Is the Wait Method not supported in Access? Any workaround? Please note
    > that I can not use the onTimer event since I will be using the method
    > within a loop code somewhat like:
    >
    > For i = 1 to 10
    > 'my code here
    > Application.Wait Now() + Timeserial (0,0,1)
    > next i
    >
    > TIA
    >
     
  3. JON JON

    JON JON
    Expand Collapse
    Guest

    That's great! Thanks.

    "Graham R Seach" <gseach@accessmvp_REMOVE.com> wrote in message
    news:%23hGGZXOeGHA.3388@TK2MSFTNGP05.phx.gbl...
    > Jon,
    >
    > Public Declare Sub Sleep Lib "kernel32" Alias "Sleep" (ByVal
    > dwMilliseconds As Long)
    >
    > Then somewhere in your code:
    > Sleep 1000 ' =1 second (1000 milliseconds)
    >
    > Regards,
    > Graham R Seach
    > Microsoft Access MVP
    > Canberra, Australia
    > ---------------------------
    >
    > "JON JON" <conrado_capistranoREMOVE@msn.com> wrote in message
    > news:OBS9wROeGHA.1264@TK2MSFTNGP05.phx.gbl...
    >> Hello NG,
    >>
    >> Is the Wait Method not supported in Access? Any workaround? Please note
    >> that I can not use the onTimer event since I will be using the method
    >> within a loop code somewhat like:
    >>
    >> For i = 1 to 10
    >> 'my code here
    >> Application.Wait Now() + Timeserial (0,0,1)
    >> next i
    >>
    >> TIA
    >>

    >
    >
     

Share This Page