By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,474 Members | 1,514 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,474 IT Pros & Developers. It's quick & easy.

IS NULL/IS NOT NULL

P: n/a
Folks,

Why is it that the only 2 choices that I have in my pull down menu of
values for each of the fields in my table are "IS NULL" AND "IS NOT
NULL?" Why are the values for the field showing up? When I'm
filtering by county for example, why don't the 88 different values for
county appear in the drop down menu?

As always, your help is genuinely appreciated!

Mike

Feb 15 '06 #1
Share this Question
Share on Google+
7 Replies


P: n/a
Br
Takeadoe wrote:
Folks,

Why is it that the only 2 choices that I have in my pull down menu of
values for each of the fields in my table are "IS NULL" AND "IS NOT
NULL?" Why are the values for the field showing up? When I'm
filtering by county for example, why don't the 88 different values for
county appear in the drop down menu?

As always, your help is genuinely appreciated!

Mike


I assume you have created some combo boxes or something? What is thier
recordsource/query?
--
regards,

Br@dley
Feb 15 '06 #2

P: n/a
I don't know what you are doing, but many things
in Access only work if the fields are indexed.

Create an index or relation on each field.

(david)

"Takeadoe" <mt********@msn.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...
Folks,

Why is it that the only 2 choices that I have in my pull down menu of
values for each of the fields in my table are "IS NULL" AND "IS NOT
NULL?" Why are the values for the field showing up? When I'm
filtering by county for example, why don't the 88 different values for
county appear in the drop down menu?

As always, your help is genuinely appreciated!

Mike

Feb 15 '06 #3

P: n/a
David - I created the table and it was populated with deer harvest data
from Verity's Teleform software. The data were exported automatically
from Teleform once the data were verified. That is the source for the
data. When I set up the table, I simply named the variables and
assigned them a type of numeric or character - simple as that. Does
this help? I will be honest - I am brand new to Access so any
suggestions have to be basic! One of the variables is county of
harvest. When others are filtering the data, it would be nice if they
could have the 88 county names show up in a drop down box.

Also - it is possible to cut a paste screen shots into messages?

MIke

Feb 15 '06 #4

P: n/a
Bradley - here is my response to David - which brings up a question
about responding to more than a single post at a time - is it possible
to reply to more than one "reply" at the same time?

Thank you for your time and help.

Mike

David - I created the table and it was populated with deer harvest data

from Verity's Teleform software. The data were exported automatically
from Teleform once the data were verified. That is the source for the
data. When I set up the table, I simply named the variables and
assigned them a type of numeric or character - simple as that. Does
this help? I will be honest - I am brand new to Access so any
suggestions have to be basic! One of the variables is county of
harvest. When others are filtering the data, it would be nice if they
could have the 88 county names show up in a drop down box.

Also - it is possible to cut a paste screen shots into messages?

Feb 15 '06 #5

P: n/a
Br
Takeadoe wrote:
Bradley - here is my response to David - which brings up a question
about responding to more than a single post at a time - is it possible
to reply to more than one "reply" at the same time?

Thank you for your time and help.

Mike

David - I created the table and it was populated with deer harvest
data

from Verity's Teleform software. The data were exported automatically
from Teleform once the data were verified. That is the source for the
data. When I set up the table, I simply named the variables and
assigned them a type of numeric or character - simple as that. Does
this help? I will be honest - I am brand new to Access so any
suggestions have to be basic! One of the variables is county of
harvest. When others are filtering the data, it would be nice if they
could have the 88 county names show up in a drop down box.

Also - it is possible to cut a paste screen shots into messages?


Back to my original question... what is the recordsource/source type of the
dropdown (combobox?)
--
regards,

Br@dley
Feb 16 '06 #6

P: n/a
It's not polite to paste screen shots into messages in this group.
(Also, some of us never read messages which include screen shots)

It may be possible to cut and paste the text from some messages:
try [Ctrl][C]. Otherwise, you just have to copy it out by hand.

You may have indexes: it depends on the name of your fields.

Go To Tools, Relationships to create relationships between fields.

I don't guarantee this will help, but I think it might.

I never use filter by form, and I never do data entry directly
into tables. If this doesn't help, you might like to re-post
with a more descriptive Subject.

(david)
"Takeadoe" <mt********@msn.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...
David - I created the table and it was populated with deer harvest data
from Verity's Teleform software. The data were exported automatically
from Teleform once the data were verified. That is the source for the
data. When I set up the table, I simply named the variables and
assigned them a type of numeric or character - simple as that. Does
this help? I will be honest - I am brand new to Access so any
suggestions have to be basic! One of the variables is county of
harvest. When others are filtering the data, it would be nice if they
could have the 88 county names show up in a drop down box.

Also - it is possible to cut a paste screen shots into messages?

MIke

Feb 16 '06 #7

P: n/a
I guess I don't know what you mean. The dropdown box appears when I
filter by form either the original table or any of the queries of this
table. If this is not what you are after, could you please be a bit
more specific?

Thank you Bradley.

Mike

Feb 19 '06 #8

This discussion thread is closed

Replies have been disabled for this discussion.