Records Affected

[Lewe22]

I am performing a series of updates from a command button on an access form. I want to record the number of records affected for each update transaction.

I have simplified some code..

Private Sub cmdTest_Click()
Dim db As Database
Dim Test1, Count1 As String

Set db = CurrentDb()
Test1 = "UPDATE TestTable SET TestTable.TestF ield = '1'" & _
"WHERE (((TestTable.Us er)='Alex Lewendon'));"

db.Execute Test1
'db.RecordsAffe cted = Count1

MsgBox "Update Complete. " & CStr(db.Records Affected) & " records were updated successfully"

End Sub

As you can see i am able to show the number of affected records in a message box, but as soon as i set that value to equal a variable i receive the error message 'can't assign to read only property'.

As my actual code is performing a number of updates i want to be able to store the number of affected records for each update. Those numbers will later be written to another table..

Does anyone have any ideas??? I'm stuck.

[hariharanmca]

Yes that is an read only property, so you cannot asigen any value.

[Lewe22]

Ok, but how can i store that value to use later??

[hariharanmca]

I cannot get what you mean?

Why you want to use it later. Do you mean overall updation in each record ?

If yes then use another field to keep counting.

[jamesd0142]

from my experience in vb.net, i had to use the fill adapter, dataset etc... in order to record how many changes where made to the database.

[Lewe22]

A record of each update performed is to be stored in a seperate 'update log' table.

The update table has the following columns:

User, Update Type, DateTime, NumberOfRecords Updated.


Perhaps there is an easier way than using 'Records Affected'???

[QVeen72]

Hi,

First declare Count1 as a Long variable and rec affected shud be on the right side:

Count1 = db.RecordsAffec ted

REgards
Veena

[Lewe22]

Thanks QVeen72. That worked perfectly!