Access update queries

[TomAtNCNY]

Is anyone aware of a system variable that holds the number of updates done
after an update query? The number displays, so it must be someplace! Another
alternative would be a boolean that indicates whether updates were done or
not. Thanks!

 

[pietlinden]

Is anyone aware of a system variable that holds the number of updates done
after an update query?  The number displays, so it must be someplace! Another
alternative would be a boolean that indicates whether updates were done or
not.  Thanks!

you mean the RecordsAffected property? Check Allen Browne's website
for an example. You'd have to run the update query in code,
though....

 

[TomAtNCNY]

This should work. It's just what I need--yes, I am running it in code so no
problem there. I appreciate your response. This is my first time using this
service and so far I am impressed.