RichNH
asked on
Access - Expand * field selection in query
Hello, I am using MS Access 2007. I am curious if there is some way I can do the following.
I want to create a query in the following manner. Open a new query, select all fields by double clicking the asterisk in the table's list of fields. Now here's the part I am curious about.
After I have selected the asterisk to get all fields I want Access to expand that asterisk to list each individual field. The end result would be the same as if I went down the list of fields in the table and selected each individual field instead of selecting the asterisk.
Why? I have tables with A LOT of fields in them, almost all of which I want selected. The key word here is "almost" which as we all know only counts in hand grenades, horseshoes and tactical nuclear weapons. I'm looking for a short cut way to avoid having to double click "almost" each and every field in the table. If I can get Access to select all the table's fields automatically, I can then just scroll over and delete the few fields I don't want.
I want to create a query in the following manner. Open a new query, select all fields by double clicking the asterisk in the table's list of fields. Now here's the part I am curious about.
After I have selected the asterisk to get all fields I want Access to expand that asterisk to list each individual field. The end result would be the same as if I went down the list of fields in the table and selected each individual field instead of selecting the asterisk.
Why? I have tables with A LOT of fields in them, almost all of which I want selected. The key word here is "almost" which as we all know only counts in hand grenades, horseshoes and tactical nuclear weapons. I'm looking for a short cut way to avoid having to double click "almost" each and every field in the table. If I can get Access to select all the table's fields automatically, I can then just scroll over and delete the few fields I don't want.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Dale Fye
Jeff, how did you capture your screencast? Camtasia?
No, there is a "screencast" option here...
(for about a few months now)
It requires Java, but it woks fairly well and in very convenient in certain cases...
;-)
Jeff
untitled.JPG
(for about a few months now)
It requires Java, but it woks fairly well and in very convenient in certain cases...
;-)
Jeff
untitled.JPG
I saw the option, but just assumed it meant I had to record the video and then upload it. So with Screencast, you just click it, and record?
<So with Screencast, you just click it, and record>
If that is so, sweet!
A picture can be worth a thousand word.
90 seconds of video can be worth a million!
If that is so, sweet!
A picture can be worth a thousand word.
90 seconds of video can be worth a million!
Yeah, I love this feature for that reason...!
Enjoy the weekend..
;-)
Jeff
Enjoy the weekend..
;-)
Jeff
ASKER
Holy selection batman, that's all there was to it??????????
:-O
:-O
ASKER
OK, Well, as you can see I gave the first answer the vast majority of points however I had to give Jeff 50 points because he is a genius and his video is slick and I was impressed.
Thank you guys, you just made my life easier... sheesch, I have to start thinking out of the box.
Thank you guys, you just made my life easier... sheesch, I have to start thinking out of the box.
Yup.
Most guys learn that early on, since the recommendation is to NOT use * unless really do need to return each and every field.
The trick is detailed here
http://office.microsoft.com/en-us/access-help/add-a-field-to-a-form-report-or-data-access-page-HP005187669.aspx
Most guys learn that early on, since the recommendation is to NOT use * unless really do need to return each and every field.
The trick is detailed here
http://office.microsoft.com/en-us/access-help/add-a-field-to-a-form-report-or-data-access-page-HP005187669.aspx
ASKER
Just tried out that screencast thing, what a neat tool!