Macro Repeat Expression

D

Dave

I would like to have a macro run multiple times using the "Repeat Expression"
until a table has zero records. What would be the syntax of the expression?

Thanks
Dave
 
K

Ken Snell \(MVP\)

Assuming that you're deleting records from a table as part of the macro's
actions, you could use a DCount function in the expression to test if the
table is empty. If the result of this expression is true,
DCount("*", "NameOfTable") = 0

then the table is empty.
 

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

Similar Threads

Macro Loop 0
How to make repeating drop-down lists? 2
Embedded Excel into Word with Tables 0
Material Costs spread across days. 0
Setting column width in a table with a macro is not working 0
Send meeting request for different dates (no repetition) to different people 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Need Help with Macro Security 1

Top