Solved

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

Posted on 2009-04-14
12
552 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
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
 
LVL 77

Expert Comment

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

Expert Comment

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

Author Comment

by:-Gil
ID: 24138068
No problem ;-)
0
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)

 

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
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 …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

920 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

17 Experts available now in Live!

Get 1:1 Help Now