Results 1 to 4 of 4
  1. #1
    Chad Access is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Sep 2015
    Posts
    44

    Error Handling "System Resources Exceeded"


    I have worked on root causing the "System Resources Exceeded" issue that I am having. Although I have no overcome it yet, I would like to use error handling to get around the Message Box that pops up.

    All I am doing is an Ontimer event to requery the report that's on the screen every 5 minutes.

    Will error handling in the vba allow me to avoid the prompt coming up? What might be an example of some code to close the report and open it back up again - I am only a novice with VBA.

    Thanks so much for your time. It is much appreciated.

  2. #2
    Beetle is offline Unrelatable
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    Camp Swampy (Denver, CO)
    Posts
    207
    What is the error number and what do you want to happen (in place of the standard application warning) when the error occurs?

    It would also be helpful if you post the code from the module in question.

  3. #3
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,069
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  4. #4
    Chad Access is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Sep 2015
    Posts
    44
    Quote Originally Posted by Beetle View Post
    What is the error number and what do you want to happen (in place of the standard application warning) when the error occurs?

    It would also be helpful if you post the code from the module in question.
    The error is "3420". I was using a macro that simply performs a requery on the object. What I'd like to do is just have it reload the object, or close it and open it back up again.

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

Similar Threads

  1. Replies: 3
    Last Post: 03-14-2016, 05:10 AM
  2. Replies: 4
    Last Post: 01-15-2016, 08:11 AM
  3. Replies: 5
    Last Post: 10-27-2014, 07:59 PM
  4. Replies: 13
    Last Post: 09-14-2014, 05:48 PM
  5. Replies: 12
    Last Post: 12-11-2012, 01:47 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
  •  
Tech Forums: Microsoft Office Forums