Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Form Problem Assistance Please

Discussion in 'Information Technology' started by Jeff, Jul 28, 2006.

  1. Jeff

    Expand Collapse

    Hi All

    Thanks to anyone who has any thoughts on these 2 questions:

    1: - Is there a maximum number of conrols you are allowed to put on a form?

    2. Can a form go corrupt?

    I am working with a form that has many controls on it (few hundred) and
    everything seemed to be working fine - then something happened that I am not
    sure what that everytime I open the form everything is all blank - (nothing
    appears on the form)- I had not backed up the database and lost about 18
    hours of work. At first it was hanging the database and creating a backup
    every time I opened it and then I was able to open it and I got a
    blank/empty form.

    Now as a workaround I created a new blank form and copied all of the
    controls and the code into the new form and I think I have gotten back
    everythign (except some minor formatting to the form).

    Has anyone every seen or experienced this? Did my form go corrupt? Is
    there anything I can do to prevent this or recover the version of the
    database with the form that is not working.

    Again thanks for any advice on this.

  2. Loading...

    Similar Threads Forum Date
    Sikh News Punjab Govt Forms Core Groups To Study Various Problems (New Kerala) Breaking News Jul 29, 2008
    Sikh News Punjab Forms Core Groups To Study Various Problems (New Kerala) Breaking News Jul 29, 2008
    Sikh News Punjab Cong Forms Panel To Study Farmers Problems (New Kerala) Breaking News Dec 16, 2007
    Sikh News Punjab Cong Forms Panel To Study Farmers Problems (New Kerala) Breaking News Dec 16, 2007
    Opinion Definition Of Diety, Human Form, God And Waheguru Sikh Sikhi Sikhism Feb 1, 2016

  3. OP
    Nikos Yannacopoulos

    Nikos Yannacopoulos
    Expand Collapse


    If you look at Access Help, Access specifications, it says:

    Number of controls and sections you can add over the lifetime of the
    form or report: 754

    Would I be right to assume that you may have reached this number during
    the design process, by adding and deleting controls? Even if not,
    corruption is not an object-specific situation, I believe; a whole
    database gets corrupted, not just a single form. By the number of
    controls you ended up with on your form, I assume your database is
    fairly complex, and you've gone through many backs and forths in your
    design, which is known to lead to corruptions.

    Tip no.1: while in development, do frequent backups (you know that now!)
    and frequent Compact and Repair.

    Tip no.2: seek ways to make your form simpler; it's not just a question
    of corruptions during development, it's primarily a question of
    usability. Users will get lost with 180 controls! Try to break it down
    to several related forms (best scenario), or use subforms or tabs (won't
    save you the corruption, but will result in a more user-friendly form).
    It is rather unlikely all 180 fields are in a single table (unless your
    design is not normalized); the way data is broken down into tables is a
    good indication toward splitting the form to several related ones, in a
    similar manner.

  4. OP

    Expand Collapse

    I am confused.

    You said when you opend the form nothing was there, so you recreated
    the form by coping all the the controls onto a new form..

    If you were able to see the controls etc on the form in design mode,
    but then when you "Opened" the form, attempting to see it with real
    data and it appeared to be completely empty the problem is not with the
    form itself. It just means that there was no data to show.

    This can happen with a read only form and the query does not return
    records, for example.
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page