S
Sue
So when is it OK to use one? Must I banish combo boxes to outer darkness?
K
Ken Snell \(MVP\)
A misunderstanding, I think. Combo boxes are very good and useful and are
not to be banned. Plus they greatly facilitate the elimination of people
entering bad data.
The "lookup" field issue relates to the property that you can set for a
field in the table itself. Don't do that! Leads to problem when you look at
data that it appears to be the lookup value but instead is the real value;
people forget that and wonder why their queries don't work when they try to
find records where that field's value is the looked-up value and not the
real value.
not to be banned. Plus they greatly facilitate the elimination of people
entering bad data.
The "lookup" field issue relates to the property that you can set for a
field in the table itself. Don't do that! Leads to problem when you look at
data that it appears to be the lookup value but instead is the real value;
people forget that and wonder why their queries don't work when they try to
find records where that field's value is the looked-up value and not the
real value.
S
Sue
Thanks for clarifying.
Ken Snell (MVP) said:
J
John W. Vinson
Well... they don't eliminate the *people*. You have to call the HR department
(or Cousin Luigi) to do that!
<g, d & r>
John W. Vinson [MVP]
K
Ken Snell \(MVP\)
John W. Vinson said:
Yep, you're right... a bit of "wishful thinking" crept into my reply.....
T
tina
hmm, do you think MS might add that option to the next version of Access?
i'd buy it in a heartbeat! <bg>
i'd buy it in a heartbeat! <bg>
K
Ken Snell \(MVP\)
tina said:
I don't think it's on the "top 100" list right now..... < s >
J
Jeff Conrad [MSFT]
in message:
It's in the specs at the moment.....
I'm kidding, just kidding!!
--
Jeff Conrad - Access Junkie - MVP Alumni
Software Development Engineer in Test
XAS Services
Microsoft Corporation
Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
It's in the specs at the moment.....
I'm kidding, just kidding!!
--
Jeff Conrad - Access Junkie - MVP Alumni
Software Development Engineer in Test
XAS Services
Microsoft Corporation
Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com
J
John W. Vinson
I think it's been on request since before there was a Microsoft... remember
the XOI instruction? Execute Operator Immediate...
John W. Vinson [MVP]
T
Tom Lake
tina said:
They had it in Alpha testing but it eliminated the entire team that was
doing the testing.
Now it's tough for MS to find people willing to work on it any further.
Tom Lake
T
tina
ROFL!!
Tom Lake said:
T
tina
Jeff Conrad said:
way cool!
I'm kidding, just kidding!!
oh darn it - you got my hopes up for .001 seconds, there!
A
Aaron Kempf
I DISAGREE!
Lookup fields ROCK
if you want to get plain text then you should use Query Analyzer or SQL
Server Management Studio
ADP uber alles
Lookup fields ROCK
if you want to get plain text then you should use Query Analyzer or SQL
Server Management Studio
ADP uber alles
A
Aaron Kempf
Conrad
stfu and fix ADP wuss
stfu and fix ADP wuss
Jeff Conrad said:in message:
It's in the specs at the moment.....
I'm kidding, just kidding!!
--
Jeff Conrad - Access Junkie - MVP Alumni
Software Development Engineer in Test
XAS Services
Microsoft Corporation
Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com