<div>
You could just run a select query on a numberic field &nbsp;first - then if the value of &quot;Count&quot; 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
</div>


<div>
<div class="content wysiwyg-content">
I have an access 2003 application that has over 100 queries<br />
<br />
at the request of the user I have turned off the query notification messages<br />
<br />
but I would still like to display a message if one of the insert or update queries has zero rows<br />
<br />
is it possible to capture the number of records impacted by a query in access vba?<br />
<br />

</div>
</div>


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?



You could just run a select query on a numberic field  first - then if the value of &quot;Count&quot; 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

Capture number of records impacted by access action query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.