Capture number of records impacted by access action query

I have an access 2003 application that has over 100 queries

at the request of the user I have turned off the query notification messages

but I would still like to display a message if one of the insert or update queries has zero rows

is it possible to capture the number of records impacted by a query in access vba?

johnnyg123Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
look at the RecordsAffected property (dao)
in VBA help, type RecordsAffected
there is also an example from the help file

or see  this link

http://msdn.microsoft.com/en-us/library/ff192040.aspx
0
 
Don ThomsonCommented:
You could just run a select query on a numberic field  first - then if the value of "Count" on any numberic field =0 pop up a message box, then run the update or append query as you normally would - You could do it with VBA code by try running it in a macro first until you know you are working, then convert the queries and mactros to VBA code
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.