Checking update changes

[robertmcbride1126]

I am reading data from one table and updating another. When the updating is completed I need to check something to see if anything was actually updated. Please tell me how can I do this. This is a stand along module not a form.

Thanks

 

[zevw]

Compare each record and see if the match. If the don't match then you want to update the data creat a flag and set to Y if anything was updated. You can also set a counter and see how many records were update in the same if statement.

 

[MichaelRed]

use the ubiquitous {F1} with the key word "RecordsAffected". Please use the installed capabilities of the applications before asking questions in these fora.




MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[zevw]

Michael!

what is this ubiquitous {F1}?

 

[robertmcbride1126]

Michael, I am sorry I should have specified that what I am using is Access and not VB to do this. Because I am not sure if this works in Access.

Do you also know how to check for when a record was successfully updated in Access also.

 

[MichaelRed]

VB ~ VBA ~ Ms. Access. Although the reference may appear only in the code pane, it is applicable.




MichaelRed
m.red@att.net

Searching for employment in all the wrong places