How to count table records in a macro


Joe M.

Hi. I have a macro that uses Transferspreadsheet action to copy a Excel
spreadsheet into a table. The table is created by the user. Prior to
importing the spreadsheet I use Delete to empty the table contents. Since the
user may create the spreadsheet incorrectly causing the import to fail
(meaning zero records will be transferred) I am trying to produce a
conditional message if there are zero records in the table. What can I put in
the condition column to test the count of the table records (i.e.
recordcount=0) ? Also the user runs the macro from a shortcut on out shared
drive and not from a form.

Joe M.


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