Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: not enough system resources to display completely.

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    119
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I receive this error when I open one of my userforms but only happens on this one form:
    "not enough system resources to display completely."
    Any idea of what is going wrong.
    Thanks in Advance
    -D

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    HI

    I guess Win95 or (* ??? If so cold boot that means shut down and re boot after 2 mins of being switched off, ad run see if works, if so resources are down, these windows are good at doing this, and no real fix bar more memory buit over 128MB and Win performance drops off, all silly really

    let me know for more ideas..

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    119
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Jack,
    Cold boot works fine, I forgot to add that the error does not generally start at start-up it is after I have been using it for awhile. I will now start tracking to see if it is a certain number of times or what brings it on. But still it has only happened with one of the userforms, and when it does I can bring up another form and will not generate the error. Weird-I say.

    Just for a little more info about the program that is causing this error. I have
    13 Userforms and the Excel file is only 1mb. It is however swapping info from upto 5 workbooks, but the total folder size is only 2.5mb.
    I was curious if I wasn't clearing some info out of memory correctly.

    I am using win ME, I've heard i really should change that and upgrade.

    Thanks Again.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Good stuff im pleased.

    I was curious if I wasn't clearing some info out of memory correctly.

    No windows at this leave is a dreadful opperating system... VBA kills it, the management of memory resources is missing not like NT4 and above so it will happen some time when you run VBA, its called dirty memory in the business, and will always get you sooner tan later.. COLD BOOT kills memory even virus retards, util loaded again..... then all over again.. cant win.

    FIX... close all apps bar excel.. and if networked and Virus checker running forget it you kill it everytime.. poss few runs then .. problems... no fix the way the OP was coded... BADLY

    Ugrade.. since you ask..

    XP is new and good from what i hear but few bad sides.. BSOD and all can cause agro as wont BSOD>>>> cheerful and few bits.. caution XP DEMANDS NEW Drivers to all hardware so UG can ruin a perfectly good system and no way to get it back.. Win2K is NT based like XP but a little friendlier... i use all these and XP has the bells a whistles but depends on your PC spec, if new PC XP ie 6 moths or less but then should be XP or very least Winy2k?? So guess you PII so bets Win2k to save the drivers issues agro... BE CAREFUL and check it all out first..

    XP require registering on line within 30 days also //////

    more info let me know...
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    119
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Do not know if it really matters but I have fiqured out what is triggering the error.

    When I run the userform from the vba editor.
    It takes about 10 activations for this to occur from what I can tell.

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    OK good news glad your happy, no real fix on that OP afraid.. suggest when need UG to NT technologies ie NT4 no longer but Win2000 also needs new drivers atc...

    good luck
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •