Yollem Crumble's latest activity

  • Y
    Yollem Crumble replied to the thread Write conflict.
    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...
  • Y
    Yollem Crumble replied to the thread Write conflict.
    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.
  • Y
    Yollem Crumble replied to the thread Write conflict.
    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...
  • Y
    Yollem Crumble replied to the thread Write conflict.
    Thanks - I think I understand that - I will experiment a bit more with the before and after update and see what occurs.
  • Y
    Yollem Crumble replied to the thread Write conflict.
    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...
  • Y
    Yollem Crumble replied to the thread Write conflict.
    The attached image shows the error on the line [Street1] = ckadd([Street1])
    • error.jpg
  • Y
    Yollem Crumble replied to the thread Write conflict.
    No it is an access table.
  • Y
    Yollem Crumble replied to the thread Write conflict.
    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...
  • Y
    I have an access table holding, amongst other things addresses of members. When an address is added or modified I trigger an "after...
Back
Top Bottom