Repeating a Macro

crmarrio

Registered User.
Local time
Today, 13:28
Joined
Feb 5, 2002
Messages
17
Hi

I have an append query that runs from a select query.

Before the append runs, there is a make table query that indicates what the next "batch" should be called

It appends the first 10 records using this batch number.

I then want to repeat the sequence until there are no records to append.

How do I do this - either in a RunMacro action or in VBA???
 

Users who are viewing this thread

Back
Top Bottom