We help IT Professionals succeed at work.

Query Builder in MS Access 2010 "improvement"

stevnated
stevnated asked
on
All I want to do is a simple query on a constant.  Say I have a table with a numeric column called "Score".  I want to enter 2 in the Criteria Section.  but it brings up a dropdown list of all the other tables and queries and operators and functions and god knows what else instead, and when I type 2 (Enter) my simple number 2 is now a query I have called [2011 Data].  I can't even type "is not null" without it wanting to insert something in the place of the word null!!!!!   Surely this is a configurable setting?  I can't find it though.  Thanks for your help, I'm a little frustrated!
Comment
Watch Question

Hamed NasrRetired IT Professional
CERTIFIED EXPERT

Commented:
try: assume table name is: tbl and field SCORE is numeric.
Click Create - Query Design - A dialog appears to select source. Click Close
Click SQL
Type the following:

SELECT  tbl.Score From tbl WHERE  tbl.SCORE =2;

Switch to Design mode and check.
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017
Commented:
Sorry, but it's been a long standing "feature" and there is no way to turn it off.

Happens in datasheets too!

Jim.

Author

Commented:
Yes, I know I can write the query that way, I just want to use the Builder.  There's nothing wrong with the query itself ... If I use SCORE = 1 it works, because there's nothing in that stupid drop-down pop-up that starts with a 1.  I can still use 2 also, but I have to hit [Escape].  I just want it back to how it was in 2003 where it doesn't try to guess what you are going to type.  It's gotta be a configuration setting somewhere ...
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
"Sorry, but it's been a long standing "feature" "
Intellisense in query designer ?

Author

Commented:
So the only way to do it is hit [Escape] after you type in your criteria?
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
<<"Sorry, but it's been a long standing "feature" "
Intellisense in query designer ? >>

 After re-reading, I'm not it's the one I'm thinking of.  The one I'm referring to is when your entering pure numbers.  When you tab to the next field, Access adds one and populates the next field.

 Drives me absolutly nuts and it's been around since A2 days.

Jim.
Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007
Commented:
Ahh ... right.
Query Intellisense SHOULD have an option to turn it OFF.  If it exists, I cannot find it.
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
Hey guys, ...

What am I missing?

<I want to enter 2 in the Criteria Section.  but it brings up a dropdown list of all the other tables and queries and operators and functions and god knows what else>

I have never seen a Dropdown box in the criteria section of the QBE grid...?

Screenshots anyone?

Jeff
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
A2010 ... start typing some expression ...

mx

Author

Commented:
I guess the main problem is I have queries that start with numbers.  So a simple query on a number pulls up my query instead.  With text fields I just have to remember to add the quotes every time.

I've only been using 2010 (from 2003) for a couple of months and am still adapting to little things ...
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
Yeah ... the 'little things'.
Welcome to our World :-)

mx
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
<A2010 ... start typing some expression ...>
?
Still not  understanding...

Explore More ContentExplore courses, solutions, and other research materials related to this topic.