Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count the number of records updated.

Status
Not open for further replies.
Sanibel

Sanibel

Technical User
Nov 15, 2001
73
GB
I am using db.execute sqlstring to update a number of records in a table. Is there a variable that contains the number of records which have been updated? If not is there any other method that I can use to find the number updated?

Thanks
 
Sort by date Sort by votes
Following the db.Execute, you can reference
[tt]
myChanges = db.RecordsAffected
[/tt]
To see the number of records Inserted, Updated or Deleted.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
1K
Andrzejek
Andrzejek
FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
751
Andrzejek
Andrzejek
M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
4K
SoftwareRT
SoftwareRT
Drago1920
  • Locked
  • Question
Finding the lowest date
Replies
2
Views
496
Andrzejek
Andrzejek
MacroAlan
  • Locked
  • Question
Empty recordset stops 1
Replies
3
Views
410
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top