Macro conditions

G

Guest

I am trying to run a 6 step macro. The first step deletes all records from a
TMP table. The second step is an import step where I import a CSV file into
the TMP table.
The CSV file will always exist but at times it will be empty. It doesn’t
matter if the import runs on an empty file but steps 3-6 cannot run if it was
empty. How can I stop a macro after completing the import step if the CSV
file was empty?

Thanks

Tom
 
K

Ken Snell \(MVP\)

Insert a macro action to StopMacro is this condition is true:

DCount("*", "NameOfTable") = 0
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top