Page 2 of 2 FirstFirst 12
Results 16 to 21 of 21
  1. #16
    wtucker is offline Advanced Beginner
    Windows 8 Access 2016
    Join Date
    Jun 2017
    Posts
    50
    Quote Originally Posted by June7 View Post
    Then suggested code should work. See post 5.
    I'm hoping to avoid this. Too much work. I might just end up using the Macro Builder and hope for the best.

  2. #17
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    I think its highly unlikely it will work using a macro when VBA fails.

    I suggest the following strategy:

    1. Make a copy of your form. Remove the MatrixUpdated control & comment out both code lines
    Does the code compile now ... or fail at another line?
    If not OK, go to step 2
    If it is OK, add a new control with the same name, restore the 2 code lines & test again.

    2. Decompile your database - this will remove any compile code including any which may be corrupted
    This link explains how & why this is useful
    http://www.fmsinc.com/MicrosoftAcces.../Decompile.asp

    Now RECOMPILE then COMPACT & try the form code again
    If it fails, go to step 3

    3. Look in the VBE and see whether you have any leftover objects starting ~TMPCLP
    If so these are objects left over after a database crash
    If you have any, read this article to see how to deal with them: https://www.access-programmers.co.uk...d.php?t=293579

    Then test the form again

    4. If you still have problems create a new database & import all objects into that

    Good luck
    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

  3. #18
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    I can no longer compile the database.
    not sure what this means. The compile option is greyed out?

  4. #19
    wtucker is offline Advanced Beginner
    Windows 8 Access 2016
    Join Date
    Jun 2017
    Posts
    50
    Quote Originally Posted by Ajax View Post
    not sure what this means. The compile option is greyed out?
    Yes, that's correct.

  5. #20
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    That means it is fully compiled.
    It's a pity MS have never modified this to popup a message telling users that!
    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

  6. #21
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    What do you mean by 'too much work'. You already have VBA procedure. Suggested edit is simple.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 03-31-2018, 04:38 PM
  2. Replies: 5
    Last Post: 08-14-2017, 02:19 AM
  3. Replies: 1
    Last Post: 03-27-2016, 10:29 PM
  4. visible form but not have focus when true
    By Ruegen in forum Programming
    Replies: 5
    Last Post: 04-30-2015, 10:31 AM
  5. Replies: 4
    Last Post: 05-29-2013, 01:29 AM

Tags for this Thread

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