Strange Problem With Form

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Wayne

    Strange Problem With Form

    I have a database that has been in use for a long period of time as an
    mde without giving any problems. I've just started making some
    changes to the main form which consists of a continuous form with 5
    subforms in the footer.

    The problem that I'm having is this: If I try to add a new text box to
    either the detail section or the header section of the main form,
    after I save the form and try to reopen it I get a bogus "out of
    memory" error. The form then won't open in design view (same out of
    memory error) and still won't open in either view if imported into a
    clean database. I decompiled, compacted, compiled and compacted
    again, to no avail.

    After deleting the form and restoring it from a backup and doing some
    experimentation , the form will allow me to add a new text box to the
    detail section if I copy one of the existing text boxes and use it.
    The form would appear to be at least partly corrupt but the problem
    only manifests under the conditions outlined above. I realise that the
    reason for this strange behaviour is probably obscure, but what sorts
    of things can cause this type of problem?
  • Arno R

    #2
    Re: Strange Problem With Form


    "Wayne" <cqdigital@volc anomail.comschr eef in bericht news:f4d9536b-9dc5-4c95-a7b3-a41118965899@y2 2g2000prd.googl egroups.com...
    >I have a database that has been in use for a long period of time as an
    mde without giving any problems. I've just started making some
    changes to the main form which consists of a continuous form with 5
    subforms in the footer.

    The problem that I'm having is this: If I try to add a new text box to
    either the detail section or the header section of the main form,
    after I save the form and try to reopen it I get a bogus "out of
    memory" error. The form then won't open in design view (same out of
    memory error) and still won't open in either view if imported into a
    clean database. I decompiled, compacted, compiled and compacted
    again, to no avail.

    After deleting the form and restoring it from a backup and doing some
    experimentation , the form will allow me to add a new text box to the
    detail section if I copy one of the existing text boxes and use it.
    The form would appear to be at least partly corrupt but the problem
    only manifests under the conditions outlined above. I realise that the
    reason for this strange behaviour is probably obscure, but what sorts
    of things can cause this type of problem?
    Maybe the form has reached its 'end of life' ('end of number of used controls' ...) ??

    You could try to create a new form.
    Copy all the controls to this new form, also copy the code and I guess it wil work again.

    A better option might be SaveAsText and LoadFromText.
    This will clear all the old 'garbage' (deleted controls and such)

    Arno R

    Comment

    • Wayne

      #3
      Re: Strange Problem With Form

      Maybe the form has reached its 'end of life' ('end of number of used controls' ...) ??
      >
      You could try to create a new form.
      Copy all the controls to this new form, also copy the code and I guess it wil work again.
      >
      A better option might be SaveAsText and LoadFromText.
      This will clear all the old 'garbage' (deleted controls and such)

      Thanks Arno.

      Comment

      • Alan

        #4
        Re: Strange Problem With Form

        On May 17, 6:35 pm, Wayne <cqdigi...@volc anomail.comwrot e:
        Maybe the form has reached its 'end of life' ('end of number of used controls' ...) ??
        >
        You could try to create a new form.
        Copy all the controls to this new form, also copy the code and I guess it wil work again.
        >
        A better option might be SaveAsText and LoadFromText.
        This will clear all the old 'garbage' (deleted controls and such)
        >
        Thanks Arno.
        Hi,

        You can try to compact and repair your database using the tool with MS
        Access. If this doesn't work, you may try some tools. If necessary,
        you may try Advanced Access Repair at http://www.datanumen.com/aar/
        This tool is rather useful in salvaging damaged Access MDB files. Hope
        this helps.

        Alan

        Comment

        • Arno R

          #5
          Re: Strange Problem With Form


          "Alan" <fyz@datanumen. netschreef in bericht news:9c3e6bf5-9db9-4b15-8198-1481c91cb5a7@p3 9g2000prm.googl egroups.com...
          Hi,
          You can try to compact and repair your database using the tool with MS
          Access. If this doesn't work, you may try some tools. If necessary,
          you may try Advanced Access Repair at http://www.datanumen.com/aar/
          This tool is rather useful in salvaging damaged Access MDB files. Hope
          this helps.
          Alan

          Hi Alan,

          Are you an a$$hole or what ??

          Please stop promoting your own software here.
          Others have asked you also.

          Arno R

          Comment

          • Keith Wilby

            #6
            Re: Strange Problem With Form

            "Alan" <fyz@datanumen. netwrote in message
            news:9c3e6bf5-9db9-4b15-8198-1481c91cb5a7@p3 9g2000prm.googl egroups.com...
            If necessary,
            you may try Advanced Access Repair at <snip>
            This tool is ...
            .... called "Alan". Please read the AUP for this group and follow the rules
            therein. This group is for *FREE* advice and support. People have been
            hounded from this group for persistent spamming.

            Comment

            • Larry Linson

              #7
              Re: Strange Problem With Form

              "Arno R" <arracomn_o_s_p _a_m@planet.nlw rote
              Hi Alan,
              Are you an a$$hole or what ??
              I trust, Arno, that is merely a "rhetorical question" -- it's clear that
              Alan is a spammer and I thought the connection to your description was "a
              given". :-)

              Larry


              Comment

              Working...