Number of records inserted

[Samantha]

I'm using SQL to insert records selected from various tables and inputs into
a temp table, by using the statement: db.Execute sql, dbFailOnError.
I need to know the number of records that are inserted into the temp table
from the db.Execute statement. Is there a way to find out this? Any help is
greatly appreciated.

 

[John Spencer]

Try the following immediately after the db.Execute statement

Msgbox db.RecordsAffected & " records inserted"



'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[Marshall Barton]

I'm using SQL to insert records selected from various tables and inputs into
a temp table, by using the statement: db.Execute sql, dbFailOnError.
I need to know the number of records that are inserted into the temp table
from the db.Execute statement. Is there a way to find out this? Any help is
greatly appreciated.

NumRecs = db.RecordsAffected

 

[Samantha]

Thank you John and Marsh. It's just what I needed!