Question: Is there a way to capture (via vba) the information from the "warnings" that pop up when running an action query in MS Access? 

As in: When an update query is run, I'd like to capture how many records are to be updated, and compare that against another variable in my code. 

And if it's possible, I'd like to keep warnings set to off! I guess I'm looking to see if there is any way to customize the action query warnings. Thanks very much in advance!

Answer: 
Use `Execute` method of ADO (see answer @Michael Z.) or DAO:

```
Dim db As DAO.Database

Set db = CurrentDb
db.Execute "SELECT * INTO someschema.sometable FROM someschema.anothertable", dbFailOnError
MsgBox db.RecordsAffected

```

Querydefs also have `RecordsAffected` property. Avoid using `DoCmd.RunSQL` commands.
I believe you are looking for `DoCmd.SetWarnings False`

<https://msdn.microsoft.com/VBA/Access-VBA/articles/docmd-setwarnings-method-access>

To obtain rows affected you'd have to run the queries like this.

```
Dim recordsAffected As Long
cn.Execute "SELECT * INTO someschema.sometable FROM someschema.anothertable", _
           recordsAffected
MsgBox recordsAffected

```