MsgBox How Meny records updated

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

zionsaal@gmail.com - 18 Jun 2007 01:07 GMT

how can I create A msg box should show how many records the run sql
cmd just updated I have the set warnings off

thanks

Reply to this Message

Allen Browne - 18 Jun 2007 02:38 GMT

See:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html

The example shows how to execute the query and display the
RecordsAffected in the MsgBox.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> how can I create A msg box should show how many records the run sql
> cmd just updated I have the set warnings off

Reply to this Message