capture number of rows to be updated (Using Acc2000, with DAO)

Topic

New Reply

Pls help.

how can I capture how many rows I am updating within my UPDATE code.

“You are about to update 0 rows” then
do this
else
do that

(Nice to work with warnings off also!)

Many thanks,

J

Reply | Quote

Replies

Use a dcount function with the same where clause as in the update query.

Reply | Quote

Use a dcount function with the same where clause as in the update query.

Reply | Quote

I think you’d have to open a recordset based on the equivalent SELECT or SELECT DISTINCT code, then get the RecordCount of the recordset. The count will not be accurate unless you move to the end of the recordset first, but it will tell you if there are records to be updated or not.

Reply | Quote

thx
got it!

Reply | Quote

thx
got it!

Reply | Quote

thx to all
got it!

Reply | Quote

thx to all
got it!

Reply | Quote

I think you’d have to open a recordset based on the equivalent SELECT or SELECT DISTINCT code, then get the RecordCount of the recordset. The count will not be accurate unless you move to the end of the recordset first, but it will tell you if there are records to be updated or not.

Reply | Quote

Use a DAO database object

dim db as DAO.Database
set db = currentdb

Then use the EXECUTE method of the database object to do the update

db.execute(“UPDATE … “)

Then call the RECORDSAFFECTED property of the database object

msgbox(“Updated ” & db.recordsaffected & ” records.”)

This should work.

You could encapsulate the operation in a transaction maybe to rollback if need be?

Reply | Quote

Use a DAO database object

dim db as DAO.Database
set db = currentdb

Then use the EXECUTE method of the database object to do the update

db.execute(“UPDATE … “)

Then call the RECORDSAFFECTED property of the database object

msgbox(“Updated ” & db.recordsaffected & ” records.”)

This should work.

You could encapsulate the operation in a transaction maybe to rollback if need be?

Reply | Quote