Results 1 to 2 of 2

Access 2007 randomly new Newrow does not appear upon editing Newrow

  1. #1
    Join Date
    Jul 2011
    Posts
    17

    Access 2007 randomly new Newrow does not appear upon editing Newrow

    This is a new one for me and I've been developing with Access for about 15 years. This problem is with Access 2007.




    This is how the program works: I have a subform in datasheet view. After entering something into a particular field of the Newrow row, the program undoes the changed row (Me.Undo), filters the records and puts the user back on the Newrow row (Me.Recordset.AddNew, or DoCmd.GoToRecord , , acNewRec - the following problem occurs either way) or it puts the user on another row depending on how the filtering went. After that, the user is either on the Newrow or can get there with the mouse or arrow keys.


    As soon as the user starts typing anything into any field on the Newrow, what should happen is that another Newrow should appear, so that he can enter another record after this one. However, this only happens some of the time. Other times, when I type something, the pencil appears as it should for this first Newrow that I am editing, but another Newrow does not appear. If I tab or click away from the row to a previous row, the pencil goes away as it should, but a new Newrow never appears.


    I have debug code that tells me that while I'm on this Newrow row, MyForm.AllowAdditions is still True, and MyForm.NewRecord is still True. If I move off to a previous row and back, MyForm.NewRecord changes to False as it should and MyForm.AllowAdditions stays True.


    This problem seems to be totally unpredictable and random. I can enter the same inputs and sometimes the new Newrow appears and sometimes it doesn't. I've tried repair & compact with no luck.


    So what to do?


    Thanks

  2. #2
    Join Date
    Jul 2011
    Posts
    17
    One other thing...

    If I start typing into the Newrow, then press Escape twice to undo what I typed, the cursor remains blinking as normal in the active field, the pencil disappears, and the Record Selector turns from gray to white. I confirm that MyForm.NewRecord = -1 and MyForm.AllowAdditions = True.

    Then, here's the kicker... If I then click the mouse to a previous row, the Newrow I was just on completely disappears and I am unable to go back to it.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access crashes when editing VBA
    By Tingholm in forum Programming
    Replies: 5
    Last Post: 01-16-2013, 12:29 AM
  2. Microsoft Access 2003 Import Issue- randomly cutting out first character
    By Bertimismaximus in forum Import/Export Data
    Replies: 9
    Last Post: 09-13-2011, 01:53 PM
  3. Access Editing
    By Brian Gregg in forum Access
    Replies: 8
    Last Post: 06-11-2011, 03:21 AM
  4. access will not allow editing
    By wthoffman in forum Access
    Replies: 3
    Last Post: 12-18-2010, 01:13 PM
  5. Replies: 1
    Last Post: 10-28-2009, 10:16 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums