locked
Why are my forms blank? RRS feed

  • Question

  • I have tested the Access Database using Access 2003, 2007 and 2010 and have the same result. I am assuming that is must have been something I did.

    I cleaned up my database by deleting extra rows in my tables that did not have a record and that were created when I imported data from an older database. The only other change is that I added code to compact and repair the database on exit. Now I have 4 forms where none of the controls are visible - the form is blank.

    What causes this?


    jim neal

    Friday, December 7, 2012 12:43 PM

Answers

  • JamesLNeal wrote:
    > ...
    > I cleaned up my database by deleting extra rows in my tables that did
    > not have a record...
    > ... Now I have 4 forms where none of the controls are visible -
    > the form is blank.
    >
    > What causes this?
     
    Basically that the record source is empty and that you can't add records
    in the form. This can happen in several scenarios. Read this kb article:
     
    --
    cu
    Karl
    *********
    Access-FAQ (German/Italian): http://www.donkarl.com
     
     
     
    • Marked as answer by JamesLNeal Monday, December 10, 2012 2:28 AM
    Friday, December 7, 2012 2:27 PM

All replies

  • If I add a record to the corresponding table the form then displays. The table is not based on a recordset or query so why would I need a record?

    jim neal

    Friday, December 7, 2012 12:54 PM
  • JamesLNeal wrote:
    > ...
    > I cleaned up my database by deleting extra rows in my tables that did
    > not have a record...
    > ... Now I have 4 forms where none of the controls are visible -
    > the form is blank.
    >
    > What causes this?
     
    Basically that the record source is empty and that you can't add records
    in the form. This can happen in several scenarios. Read this kb article:
     
    --
    cu
    Karl
    *********
    Access-FAQ (German/Italian): http://www.donkarl.com
     
     
     
    • Marked as answer by JamesLNeal Monday, December 10, 2012 2:28 AM
    Friday, December 7, 2012 2:27 PM