Msgbox - number of rows pasted and time

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
 
S

Steve Schapel

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
Access Subscript out of range when importing into access 2010 from excel 0
Excel message box 5
Pasted Text Won't Fill Page - Please Help 2
Using a macro to run an update querey 1
How can I show the number of rows pasted by a macro? 3
Ccreate Macro with MsgBox. Pls. help! 7
Access Macro Repeat Expression using value of a field in table 0

Top