General discussion


Running multiple Access queries

By No_Problem ·
I have 10 macros that I need to run one after the other. However, I would like for one to run and wait maybe 1 minutes before it runs the next or wait for a keyboard command before it runs the next. What is the best way to do this?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by ESchlangen In reply to Running multiple Access q ...

One simple way to wait for a specified amount of time is this:

Public Sub Pause(iSeconds As Integer)
Dim dStart As Date

dStart = Now()
Debug.Print dStart
Do Until DateDiff("s", dStart, Now()) >= iSeconds

End Sub

You should be able to do something similar for a keypress, I haven't tried. Hope this helps!

Related Discussions

Related Forums