Message box when query finished

[Tony Williams]

I have a number of command buttons that run various queries when clicked.
Some run extremely quickly and I want a customised message box to pop up and
say somrthing like "Update query finished, ?? number of records updated" or
"Delete query finished, ?? number of records deleted" or "Append query
finished, ?? number of records added"

Is this possible and how would I start with this?
Thanks
Tony

 

[Tom van Stiphout]

On Thu, 19 Feb 2009 04:36:00 -0800, Tony Williams

Depending on with version of Access you are using I think the help
file may have an example. It goes along the lines of:
dim db as dao.database
set db = currentdb()
db.execute "myActionQuery", dbFailOnError
msgbox "myActionQuery succeeded. Records affected: " &
db.RecordsAffected.

-Tom.
Microsoft Access MVP