MS Access Query Mysteriously Pulling All Fields

CPGDeveloper

Board Regular
Joined
Oct 8, 2008
Messages
146
Hi All ~

A colleague of mine is having trouble with her MS Access -- when she tries to write a new query, even a very simple one, it will include all fields in the table, even if she is only including one or two fields. This is not happening on anyone else's MS Access.

Before we put in a request to re-install her MS Access, I just wanted to check if there is some strange setting that I am unaware of.
 

Micron

Well-known Member
Joined
Jun 3, 2015
Messages
1,981
Office Version
  1. 365
Platform
  1. Windows
you're welcome! So glad that I was able to save you from doing a re-install that just might have saved that property setting. I recently switched from 64 to 32 bit Office and noticed some Access settings were still there afterwards. You might have gone through that process only to find that option was saved too!

While composing this I thought I'd search to see if I could find a logical reason for the property. I didn't find one, but wow, I did find that it is in the query property sheet too! Supposedly the reason is that it's simpler than checking the box for a whole lot of fields, which I still don't see the point of. If you drop each table field onto the grid, it gets checked anyway. If you drop on the asterisk* you get all the fields (mind you, you cannot add criteria by doing only that).

So here we have a feature that probably only 10% of users know about, yet we can't get serious things fixed after years of asking.
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

xenou

MrExcel MVP
Joined
Mar 2, 2007
Messages
16,761
Office Version
  1. 2019
Platform
  1. Windows
I had never heard of this either - funny one. Certainly a quirk of the query designer. I thought you could always get all fields onto the grid by with some kind of multi-select as well, and just drag them all on ... and I just realized my new job didn't put Access on my machine :(
 

Watch MrExcel Video

Forum statistics

Threads
1,118,602
Messages
5,573,166
Members
412,510
Latest member
shp0590
Top