Hi, I am stuck on what I assume is something obvious, I’m not that familiar with Base so apologies. I am working on a Corporate db so can’t show the code, so have a made up db for this example.
The DB is “DB1”, with a table “tblTable1” which has two fields “A” and “B” both integers, “A” has values in it and “B” is empty, there is no primary key! What I’m trying to do is write a macro that steps through each record in turn, reads in the value of “A”, does some clever maths! In this case just adds two, then updates the “B” field in that record with the answer, then moves to the next record etc etc.
I have done most of the code which seems to work until I try to update “B” then I get an error about the table being Read Only, which I can’t get around. I haven’t included any code as I’m interested to see what someone who knows what they are doing would do.
Any help greatly appreciated.