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")
 

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

Need to know number of rows pasted 1
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
DCount 2
MsgBox - autoexec macro 4
using excel vba ope a word doc and copy-paste into another word doc 0
Export, Copy/Paste and Save with date possible with macro? 2
Access Macro Repeat Expression using value of a field in table 0
Stop macro after selecting 'no' 0

Back
Top