Need to know number of rows pasted

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

Tiff

When a macro is used to run a make table query, is there anyway to get the
message box to tell me the count as it would if I had not turned off the
warnings?

thank you

tiff
 
Tiff,

Yes. After the Make-table has run, you can use a MsgBox action in your
macro, with the Message Text set to:
=DCount("*","NameOfTable")
 
Back
Top