Results 1 to 4 of 4
  1. #1
    stephens114 is offline Novice
    Windows 8 Access 2007
    Join Date
    Feb 2018
    Posts
    2

    Access issue when adding a command button

    Good morning,
    I have a split database in use which consists of two main forms. On one of the forms I am trying to add a command button to duplicate the record selected. Every time I do this I save it, come out and when I go back in I enter data into the first box (which is a combo box) and the display box 'Microsoft Access has stopped working' appears and shuts down. When I go back in and take the button out the database works fine.


    Can anyone help? I have been looking at this for a while but cannot seem to find a solution.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    This bug can happen esp with mixed versions of access. (created in 2007, and modified in 2010)
    Theres no really good way to stop it. The same bug will not fail on 1 pc , but does on another.

    What may work, make a new db, (keep the version you have)
    import everything.
    This may help cleanup issues.

  3. #3
    stephens114 is offline Novice
    Windows 8 Access 2007
    Join Date
    Feb 2018
    Posts
    2
    Thanks Ranman I will give that a go

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    In my experience, this happens when vba code gets corrupted.
    To solve, you should decompile to remove compile code, then recompile and finally compact.

    For more info on decompiling see https://www.fmsinc.com/MicrosoftAcce.../Decompile.asp
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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

Similar Threads

  1. Adding a record will add a command button
    By NickWren in forum Programming
    Replies: 8
    Last Post: 04-04-2017, 07:11 PM
  2. Command Button Border Transparency Issue!
    By JeffG3209 in forum Database Design
    Replies: 4
    Last Post: 06-29-2011, 07:50 PM
  3. Adding Pop-ups via Command Button
    By jlclark4 in forum Forms
    Replies: 1
    Last Post: 01-05-2011, 02:41 PM
  4. Command button issue
    By sloppysly in forum Forms
    Replies: 8
    Last Post: 06-15-2009, 12:07 PM
  5. Adding Command Button To Form
    By uneek78 in forum Forms
    Replies: 7
    Last Post: 03-27-2009, 07:43 PM

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