Pausing my Macro??

[Michael T]

Hi

I have a macro that runs a number of other macros I don't know how to programme hence doing things this way.

Macro1 opens up a query in design view which I need to edit before Macro2 kicks in. The problem is the master macro just runs both Macros without stopping so I can't edit the file Macro1 opens. Is there a way other than running the Macros separately to pause the Master Macro until I have edited the file Macro1 opens.



If possible I would like to continue using Macros rather than VB code.

Thanks in advance

Michael

[pbaldy]

The only thought that comes to mind would be to throw up a message box after opening the query. If a macro is like code, it will wait for the message box to be closed before continuing.

Why are you opening a query in design view? There is typically a better alternative to letting users into query design view. I've never done it.

[Amicron]

Michael, I'm GUESSING you're opening up a query in design view to specify some parameters, such as a date or name. Do you know how to create a PARAMETER QUERY? If not, check out this tutorial:

http://599cd.com/X4KNFO

You can have the query stop the user for the parameters, or you can even set up a FORM to type in the parameters first, like this:

http://599cd.com/XFKUBQ

Now, rather than continuing on with macros, this sounds like it might be an EASY job for a little tiny bit of VBA code. Using VBA isn't as intimidating as it seems. Once you get the hang of it, it's really much easier than even using macros.

If you'd like to tell us a little more about WHAT your macro does, I'm sure someone (including myself) would be happy to help you. I'm relatively new to AccessForums.net myself and I wish I had more time to spend here... but if I have time to get on soon I'd be happy to assist you.