Search results

Thankyou to those that responded. Some of the comments have taken me off in another direction, but for the record, I think I have solved the problem. I have removed all data validation code that uses a Dynaset recordset. I believe these were the "other user" that was making changes to the record...

The query got overly complicated as it depends on so many variables. That is why I decided to ditch the query and just store it.

On further reading, updating the field through a beforeUpdate event causes an error. It needs to be done after the update so as not to cause a conflict in the field being updated. That still leaves me with a write conflict which I now suspact is caused by altering the field (or other fields) in...

Thanks - I think I understand that - I will experiment a bit more with the before and after update and see what occurs.

Ken - thanks for your reply. The database in mostly fully normalised but I found I was taking too long to create files to upload to our e-mail provider, so decided to add two fields with dependancies. I fail to see how that creates the write conflict.

The attached image shows the error on the line [Street1] = ckadd([Street1])

No it is an access table.

The dirty lines are my attempt to save previous edits. I removed them and shifted the code to before update. The code crashes on the checkadd function which will not allow me to update the field. Actually the ckadd fuction is the only validation line of code. the rest is updating other fields...

I have an access table holding, amongst other things addresses of members. When an address is added or modified I trigger an "after update" event to correct abbreviations and also to populate another field in the record with a "full address" which is used for many other purposes. The problem I...

Hi - I am new to this site but have been using MS Access with a ton of VBA behind for many years. Usually I can solve most problems but recently came across one I need help with. I have a form drawing data from a table. It contains a field for town/suburb and a field for Post code (Zip Code) I...