Autoexec macro

[Rich Young]

I have created a macro that will copy a text file from a server location and
saves it as a different name to my local drive. I have a second macro that
imports the file into the db and runs a couple of queries. That all seems to
work fine when run separately. With that being said, I want to create a
autoexec macro that runs both macros upon opening the db. The problem is
that when run them in one macro by using the RunMacro command, I receive an
error. Apparently the second macro begins to run before the first one has
finished.

Does any one know how I can prevent the second macro from running until the
first is complete?

Thanks,
Rich

 

[bhicks11 via AccessMonster.com]

There's a custom function someone has written and shared that might help. I
use it with success. Here's the link:

http://www.mvps.org/access/api/api0004.htm

Bonnie
http://www.dataplus-svc.com

 

[KARL DEWEY]

Try reversing the order of the macros in the autoexec. Import from server
first and second copy to local drive.