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

    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 MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    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

  4. #4
    Chad Access is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Sep 2015
    Posts
    49
    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
  •  
Other Forums: Microsoft Office Forums