Results 1 to 3 of 3
  1. #1
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659

    Question Auto Backspace Error

    In Access I have encountered the bug described here


    http://stackoverflow.com/questions/8...cel-vba-editor

    The reference Lib that I am using is just another Access Database. To fix the issue I have to remove the reference in the from the IDE and re-apply the reference. This is a pretty annoying issue. Does anyone know how it starts to occur? I am not using any 3rd party tools with access.

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Actually I've seen this problem posted numerous times, over the years, and the usual culprit is a Timer Event that is running, either in the Form in question...or another Form, if open at the same time. I'm guessing it's in the same Form, in this case, or in the exterior database that you're referencing, and when you remove the reference to the library/db, you're halting all code from firing.

    The trick is to find out where the Timer is running and disable it while you're developing your db.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    I will check my timers.

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

Similar Threads

  1. Auto complete & auto add
    By Pete Moss in forum Forms
    Replies: 3
    Last Post: 12-19-2015, 11:40 AM
  2. Auto Populate SQL with Run-Time Error 3464
    By excellenthelp in forum Programming
    Replies: 4
    Last Post: 08-04-2014, 12:03 PM
  3. Replies: 0
    Last Post: 07-16-2012, 05:42 AM
  4. Replies: 3
    Last Post: 11-04-2011, 01:50 PM
  5. Auto Run Report then Auto Email
    By jo15765 in forum Reports
    Replies: 1
    Last Post: 10-05-2011, 10:57 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
  •  
Other Forums: Microsoft Office Forums