Run Macro Repeat Count

B

Bertie

Hi, I want to set the repeat count of a macro to be the number of records
in a table - what is the variable for this?

Cheers
 
S

Steve Schapel

Bertie,

One approach to this would be to make a continuous view form based on
the table, in the footer of the form put an unbound textbox with its
Control Source set to =Count(*) and then in the Repeat Count argument of
the RunmMacro action, refer to this textbox using syntax such as
=[Forms]![MyForm]![MyTextBox]
 

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 open multiple instances of Word 365? 5
Setting column width in a table with a macro is not working 0
Embedded Excel into Word with Tables 0
Send meeting request for different dates (no repetition) to different people 0
Remove Identical words 0
Apple Script in Outlook 365 Mac keystrokes blocked on M1 mac 0
Select Text to End of Footnote 9

Top