Multiple Macros within a Macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tj - 25 Feb 2004 17:00 GMT

I have created a macro that runs 2 macros.
The first executes a batch files that takes 14 ASCII files
(with non-Access compatible extension), combines into one
file and renames the extension to .txt.
This takes several seconds.

The second SHOULD import the .txt file into a table.

The import does not happen. I think the second macro is
attempting to run before the first has completed. No error
message or anything. The import macro runs perfectly if
you execute it independently.

Any ideas?

Reply to this Message

Steve Schapel - 25 Feb 2004 18:12 GMT

Tj,

The only way I know of around this is to use a SetValue action at the
end of the first macro, to set the TimerInterval propeerty of a form
which is open at the time you are running this procedure, to for example
5000 (i.e. 5 seconds), and then assign the second macro separately on
the On Timer event of the form.

Signature

Steve Schapel, Microsoft Access MVP

> I have created a macro that runs 2 macros.
> The first executes a batch files that takes 14 ASCII files
[quoted text clipped - 10 lines]
>
> Any ideas?

Reply to this Message