Recent content by derekaustin

  1. D

    Multi-Line Paste Failure Into SubForm Leaves Uncommitted Internal Transaction

    Thanks again Pat. Good to know I'm not going mad. What would you recommend I do next? The issue appears to exists in MS Access 2010, 2014 and 2016. MS should address this ASAP?
  2. D

    Multi-Line Paste Failure Into SubForm Leaves Uncommitted Internal Transaction

    The pasted records not being visible after the failed paste is not the problem - as you correctly pointed out that's to be expected when pasting a unique key. In this post attempting to paste unique keys is only a means to an end i.e. a simple way to generate a paste error. After the paste...
  3. D

    Multi-Line Paste Failure Into SubForm Leaves Uncommitted Internal Transaction

    Hi Pat - thanks for replying. The failure to paste a unique index into a new record is as expected. What surprised me was that after the paste failure I could go on to add records that were lost when I closed the form. Looks like the paste failure has left the form in the middle of an...
  4. D

    Multi-Line Paste Failure Into SubForm Leaves Uncommitted Internal Transaction

    I have created a very simple Access 2010 database. It has 2 tables: tblParent and tblChild. Each has a primary key on a single numeric column: called ParentId and ChildId respectively. Each has an additional Index (No Duplicate) on text name columns: called Parent and Child respectively...
Top Bottom