Access update queries

T

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!
 
P

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!
Click to expand...

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

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.
 
Top