Records affected by running by docmd.openquery

  • Thread starter Thread starter lowestbass
  • Start date Start date
L

lowestbass

I am building a database with approximately 70 queries which I am
running from VBA. I have disabled messages, but I would like to
creae a log of the records that have been updated by each query. Is
there a way of finding out how many records are updated when using
"docmd.OpenQuery" and when using DoCmd.RunSQL.

Thank you in advance for your help.

Jeremy Lowe
 
Use Execute instead of RunSQL.

Example:
With dbEngine(0)(0)
.Execute "Query1", dbFailOnError
Debug.Print .RecordsAffected
End With
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Docmd.openquery causes error 4
What Do You Use Instead of DoCmd.OpenQuery or DoCmd.RunSQL 2
DoCmd.Openquery question 3
Capture which query is being run 3
Resume Next versus GoTo 5
VB Delete Opinion 5
Run three Queries in VBA consecutively... 2
Determing the Number of Records in an Append Query 3

Back
Top