Corrupted form/control

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

    #1

    Corrupted form/control

    I posted the other day that the Incremental Search box that I had been using
    was no longer working properly. When I checked the code against an older
    version that was working properly, the changes to the code from the old
    (good) to the new (bad) version were minor and seemed unlikely to be the
    cause of a problem. I then changed them one-at-a-time back to the old
    version. Finally, the code blocks seemed identical. Just to be sure, I
    copied all of the code from the good form to the bad form and the bad form
    still did not work.

    But then I copied the ListBox control itself from the good form to the bad
    form and then the bad form suddenly worked fine. IOW, I had a corrupted
    control.

    Q: Is there a better way to test for a corrupted control than to pound
    your head against a wall for a few days, some testing procedure, some
    checksum value, anything?

    Q: Even though things are working now, is it likely that the form itself is
    corrupted and that the control will become unstable again?

    Q: What, if anything, should I do now?



    Thanks
    CA


  • Allen Browne

    #2
    Re: Corrupted form/control

    Good troubleshooting .

    Based on our experiences, there are several things you can do to prevent the
    corruption recurring. We listed them in this article:
    Preventing corruption
    at:
    Steps to reduce the likelihood of corruption in a Microsoft Access database. Explains how corruptions occur, how to prevent corruption of installed databases, and now to minimize corruption during database development.

    The first 4 items are the most crucial.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Colleyvill e Alan" <aecharbonneau@ nospam.comcast. net> wrote in message
    news:wKMEc.7900 $%_6.4186@attbi _s01...[color=blue]
    > I posted the other day that the Incremental Search box that I had been[/color]
    using[color=blue]
    > was no longer working properly. When I checked the code against an older
    > version that was working properly, the changes to the code from the old
    > (good) to the new (bad) version were minor and seemed unlikely to be the
    > cause of a problem. I then changed them one-at-a-time back to the old
    > version. Finally, the code blocks seemed identical. Just to be sure, I
    > copied all of the code from the good form to the bad form and the bad form
    > still did not work.
    >
    > But then I copied the ListBox control itself from the good form to the bad
    > form and then the bad form suddenly worked fine. IOW, I had a corrupted
    > control.
    >
    > Q: Is there a better way to test for a corrupted control than to pound
    > your head against a wall for a few days, some testing procedure, some
    > checksum value, anything?
    >
    > Q: Even though things are working now, is it likely that the form itself[/color]
    is[color=blue]
    > corrupted and that the control will become unstable again?
    >
    > Q: What, if anything, should I do now?[/color]


    Comment

    • Colleyville Alan

      #3
      Re: Corrupted form/control

      Thanks for the info.

      "Allen Browne" <AllenBrowne@Se eSig.Invalid> wrote in message
      news:40e39c4a$0 $24753$5a62ac22 @per-qv1-newsreader-01.iinet.net.au ...[color=blue]
      > Good troubleshooting .
      >
      > Based on our experiences, there are several things you can do to prevent[/color]
      the[color=blue]
      > corruption recurring. We listed them in this article:
      > Preventing corruption
      > at:
      > http://allenbrowne.com/ser-25.html
      > The first 4 items are the most crucial.
      >
      > --
      > Allen Browne - Microsoft MVP. Perth, Western Australia.
      > Tips for Access users - http://allenbrowne.com/tips.html
      > Reply to group, rather than allenbrowne at mvps dot org.
      >
      > "Colleyvill e Alan" <aecharbonneau@ nospam.comcast. net> wrote in message
      > news:wKMEc.7900 $%_6.4186@attbi _s01...[color=green]
      > > I posted the other day that the Incremental Search box that I had been[/color]
      > using[color=green]
      > > was no longer working properly. When I checked the code against an[/color][/color]
      older[color=blue][color=green]
      > > version that was working properly, the changes to the code from the old
      > > (good) to the new (bad) version were minor and seemed unlikely to be the
      > > cause of a problem. I then changed them one-at-a-time back to the old
      > > version. Finally, the code blocks seemed identical. Just to be sure, I
      > > copied all of the code from the good form to the bad form and the bad[/color][/color]
      form[color=blue][color=green]
      > > still did not work.
      > >
      > > But then I copied the ListBox control itself from the good form to the[/color][/color]
      bad[color=blue][color=green]
      > > form and then the bad form suddenly worked fine. IOW, I had a corrupted
      > > control.
      > >
      > > Q: Is there a better way to test for a corrupted control than to pound
      > > your head against a wall for a few days, some testing procedure, some
      > > checksum value, anything?
      > >
      > > Q: Even though things are working now, is it likely that the form itself[/color]
      > is[color=green]
      > > corrupted and that the control will become unstable again?
      > >
      > > Q: What, if anything, should I do now?[/color]
      >
      >[/color]


      Comment

      • Colleyville Alan

        #4
        Re: Corrupted form/control

        Thanks for the info.

        "Allen Browne" <AllenBrowne@Se eSig.Invalid> wrote in message
        news:40e39c4a$0 $24753$5a62ac22 @per-qv1-newsreader-01.iinet.net.au ...[color=blue]
        > Good troubleshooting .
        >
        > Based on our experiences, there are several things you can do to prevent[/color]
        the[color=blue]
        > corruption recurring. We listed them in this article:
        > Preventing corruption
        > at:
        > http://allenbrowne.com/ser-25.html
        > The first 4 items are the most crucial.
        >
        > --
        > Allen Browne - Microsoft MVP. Perth, Western Australia.
        > Tips for Access users - http://allenbrowne.com/tips.html
        > Reply to group, rather than allenbrowne at mvps dot org.
        >
        > "Colleyvill e Alan" <aecharbonneau@ nospam.comcast. net> wrote in message
        > news:wKMEc.7900 $%_6.4186@attbi _s01...[color=green]
        > > I posted the other day that the Incremental Search box that I had been[/color]
        > using[color=green]
        > > was no longer working properly. When I checked the code against an[/color][/color]
        older[color=blue][color=green]
        > > version that was working properly, the changes to the code from the old
        > > (good) to the new (bad) version were minor and seemed unlikely to be the
        > > cause of a problem. I then changed them one-at-a-time back to the old
        > > version. Finally, the code blocks seemed identical. Just to be sure, I
        > > copied all of the code from the good form to the bad form and the bad[/color][/color]
        form[color=blue][color=green]
        > > still did not work.
        > >
        > > But then I copied the ListBox control itself from the good form to the[/color][/color]
        bad[color=blue][color=green]
        > > form and then the bad form suddenly worked fine. IOW, I had a corrupted
        > > control.
        > >
        > > Q: Is there a better way to test for a corrupted control than to pound
        > > your head against a wall for a few days, some testing procedure, some
        > > checksum value, anything?
        > >
        > > Q: Even though things are working now, is it likely that the form itself[/color]
        > is[color=green]
        > > corrupted and that the control will become unstable again?
        > >
        > > Q: What, if anything, should I do now?[/color]
        >
        >[/color]


        Comment

        Working...