Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2005
    Posts
    91

    Unanswered: Datasheet View Problem

    I have a problem that I am sure is fairly simple to fix but for some reason I can't figure out. I opened a form in my access program and then switched from the 'Form View' to the 'Datasheet View' by selecting View > Datasheet View on the menu bar. I sorted the datasheet view by one of the columns and then deleted a few rows. I then returned to the form view and everything was fine. I later tried switching back to datasheet view and noticed that the datasheet view option was disabled. I reenabled the datasheet view by switching to design view on the form, accessing the forms properties and then allowing the datasheet view on the forms properties. This enabled the datasheet view option but now the datasheet list is empty. There is definitely data there but for some reason it does not appear on the dataview. I may have previously set a filter on the dataview but I can't figure out how to unfilter the grid because the filter option on the toolbar is disabled. The odd thing however is that only one cell is now displayed on the datagrid versus the many columns that I know exist and were previously displayed. Can someone please help me figure out how I can view the data back on the dataview.


    Thanks!

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Odd one. I've never seen a form do that without "help".

    Is there a Filter in the Filter property for the form?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Nov 2005
    Posts
    91
    No there are no filters set on the form and there are no hidden columns.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Make sure you take regular backups so you can restore your files back to a time you choose.

    Create a new form and copy the objects across? Should fix it if there is some corruption in the form.

    How big is the form? Would that be a big undertaking?

    Other things you can try:
    Restore the database from a backup, import the old form into the new database if needed.
    Check all the form properties for something amiss.
    Check the menus and try Remove Filter and such.

    I can't think of anything else that could do that.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Nov 2005
    Posts
    91
    StarTrekker thank you for the help!. The problem was indeed due to a filter that I overlooked on the forms properties. I guess long hours at work will do that to you.

    Thanks again!

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yes, long hours can be detrimental to good focus!

    Happy to help
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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