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
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
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!