Number of records appended

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm creating a log that will store the time, username and the number of
records returned(appended) by an append query. The time and username is very
easy, my problem is logging the number of records.

Is there a property in Access VBA that i can access programmatically to know
the number of records appended by an action query?

Any ideas (no matter how wild) will be most appreciated. thanks in advance.
 
V Ramos said:
I'm creating a log that will store the time, username and the number
of records returned(appended) by an append query. The time and
username is very easy, my problem is logging the number of records.

Is there a property in Access VBA that i can access programmatically
to know the number of records appended by an action query?

Any ideas (no matter how wild) will be most appreciated. thanks in
advance.
Click to expand...

Dim db As DAO.Database

Set db = Current Db

db.Execute "MyAppendQuery", dbFailOnError

Msgbox "Hey, I just appended " & db.RecordsAffected & " records!"

Set db = Nothing
 
Dirk Goldgar said:
Dim db As DAO.Database

Set db = Current Db

db.Execute "MyAppendQuery", dbFailOnError

Msgbox "Hey, I just appended " & db.RecordsAffected & " records!"

Set db = Nothing

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


thanks a lot dirk, this is the code i needed.
Click to expand...
 
Back
Top