Solved

Filter by form mostly showing is null / is not null access 2003

Posted on 2009-04-14
12
551 Views
Last Modified: 2013-11-28
What factor is access decides which fields will have data to filter by in FILTER BY FORM while others say is null / is not null.

Or why does this happen.

Thanks Gil
0
Comment
Question by:-Gil
  • 8
  • 2
  • 2
12 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 250 total points
Comment Utility
is null--- meaning there is nothing in the field where you placed the criteria

is not null  -- is just the opposite of  { is null }
0
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 250 total points
Comment Utility
I would think you will get Null/Not Null for OLEObject fields as the data can't be shown for selection.
0
 

Author Comment

by:-Gil
Comment Utility
I'm sorry I tend not to be clear in my questions.
I would like to know why some fields you can filter with the data while other fields only show is null / is not null.

For example if I click FILTER BY FORM

Field a  (Will show)    is null/ is not null
Fiels b (will show)     CAT / Dog
Field c (will show)     is null/ is not null

Why does field a and b show is null/ is not null while field b shows CAT/ DOG

0
 
LVL 77

Expert Comment

by:peter57r
Comment Utility
What I said before..
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
sorry, misread your question...;-(
0
 

Author Comment

by:-Gil
Comment Utility
No problem ;-)
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

Author Comment

by:-Gil
Comment Utility
Is an OLEObject fields a picture field?

UPDATE
I went in and opened a previous backup of my db and the filter by form worked just fine.
It seems like just recently it started to do this.  Ive been checking and its not one form or table its my whole DB.   The only fields that I can choose with data are combo boxes and a field where no duplicates  
may exist.
0
 

Author Comment

by:-Gil
Comment Utility
Update

My Find/Replace button is not working.

You can open it but you cant search or replace anything.   I tried typing in the value of the field to replace and it didn't work?

What gives.
0
 

Author Comment

by:-Gil
Comment Utility
I deleted things little by little to try and find what happened or at least where I went wrong and I think it was a field I had added in one of my tables.


0
 

Author Comment

by:-Gil
Comment Utility
Sorry to open the question but deleting things was not the correct solution it was more of a quick fix, did not solve the underlying problem.

Here is what I think
1) I some how changed the DATABASE DEFAULT  FILTER LOOKUP.
   If I set that property to ALWAYS(in DATA tab in properties) instead of data base default then it works.

2)If I go back to my table and change a property to INDEX(duplicates ok) then it works. I left the filter look field property at database default.

Any ideas on how to get it back
0
 

Author Comment

by:-Gil
Comment Utility
Sorry to open the question but deleting things was not the correct solution it was more of a quick fix, did not solve the underlying problem.

Here is what I think
1) I some how changed the DATABASE DEFAULT  FILTER LOOKUP.
   If I set that property to ALWAYS(in DATA tab in properties) instead of data base default then it works.

2)If I go back to my table and change a property to INDEX(duplicates ok) then it works. I left the filter look field property at database default.

Any ideas on how to get it back
0
 

Author Closing Comment

by:-Gil
Comment Utility
Thanks
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now