Msgbox - number of rows pasted and time

  • Thread starter Thread starter Tiff
  • Start date Start date
T

Tiff

We currently run a make table query from a macro and set the warnings to no
and a message box stating the time the query completed it's action, we would
like to be able also have the number of rows pasted in the message box.

thank you

tiff
 
Tiff,

You could use a DCount function within your message text expression:
DCount("*","NameOfNewTableCreated")
 
Back
Top