B
B. Meincke
I have a macro in which I need to set a condition that checks whether or not
the recordset of a Make Table query in the same database is null or not. As
the query finds errors created by other macro actions, if it's recordset is
null, I need the macro to continue, but if it is not, I need the macro to
pause and the table the query in question creates to open and display its
contents.
Is this possible?
If so, how do I go about writing the macro syntax for the condition?
Thanks in advance for any ideas or advice.
the recordset of a Make Table query in the same database is null or not. As
the query finds errors created by other macro actions, if it's recordset is
null, I need the macro to continue, but if it is not, I need the macro to
pause and the table the query in question creates to open and display its
contents.
Is this possible?
If so, how do I go about writing the macro syntax for the condition?
Thanks in advance for any ideas or advice.