Run One Macro At A Time

[mous]

Using Access 97.

I have created a macro whereby it simply runs a series of imports and queries. Some of the queries run on tables that have yet to be imported.

Is there a wait / pause / loop / stop until function that run the first macro. Ensures that its finished then goes on to the next, so on and so on.

If this is only achieved by VB can you give me a sample please I'm new to VB.

Many Thanks

Dawn

 

[spacepro]

This link might help you.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/achowMakeMacroRunCertainConditionsS.asp

HTH
Andy