+ Reply to Thread
Results 1 to 2 of 2

Filters blank and compact repair not working

  1. #1
    Registered User
    Join Date
    04-16-2012
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    13

    Filters blank and compact repair not working

    Hi

    Office 2010

    I've got this DB on a network share at work and just recently I noticed one or two of the fields in the table columns filter doesn't have any data when I click on the dropdown. This is when in datasheet view. A couple of months ago we had 2010 installed and this DB is a 2007 version, however at the time never noticed any problems then.

    I've also tried running compact and repair but it doesn't seem to do anything. Tried saving to local drive and doing it there to no avail.

    Is this a common problem with access?

    Thanks

    G

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,872

    Re: Filters blank and compact repair not working

    If you open the related (bound) tables, does it hold the particular data you are expecting?
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Filters : Not Equals <> with Filters is not working !!!!
    By vishulive in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2015, 01:40 AM
  2. [SOLVED] Remove Blank Cells and Sequential Series to Compact List of Elements
    By JCatlow in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-24-2015, 08:41 PM
  3. Filters not working together
    By SHUTTEHFACE in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-30-2014, 10:21 AM
  4. working w/ filters
    By zazzz in forum Excel General
    Replies: 2
    Last Post: 10-11-2012, 10:09 AM
  5. Replies: 0
    Last Post: 06-25-2012, 03:28 PM
  6. working with filters
    By Daanish in forum Excel General
    Replies: 2
    Last Post: 09-01-2010, 12:02 PM
  7. Compact/Repair Access Database
    By pr4t3ek in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2009, 04:41 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1