Solved

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

Posted on 2009-04-14
12
553 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 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 250 total points
ID: 24137768
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
ID: 24137810
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
ID: 24137830
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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 77

Expert Comment

by:peter57r
ID: 24137861
What I said before..
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 24138042
sorry, misread your question...;-(
0
 

Author Comment

by:-Gil
ID: 24138068
No problem ;-)
0
 

Author Comment

by:-Gil
ID: 24141212
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
ID: 24141700
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
ID: 24142111
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
ID: 24147976
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
ID: 24147982
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
ID: 31569873
Thanks
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Programmer 14 49
Passing variables to a function 6 35
Why get error when delete all records on a sub-form 2 16
Problem copying record details to a new record 5 8
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

773 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