John W. Colby
jcolby at colbyconsulting.com
Tue Mar 4 18:13:00 CST 2003
MessageNope, it shows false. That is what I am trying to say, it is using
the default value as the "position" selector, i.e. select the 0th element in
the list (it is zero based), select the 1st element in the list etc.
John W. Colby
Colby Consulting
www.ColbyConsulting.com
----------------------------------------------------------------------------
----
I've stopped 9,259 spam messages. You can too!
Get your free, safe spam protection at www.cloudmark.com
-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Charlotte Foust
Sent: Tuesday, March 04, 2003 6:59 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] default values for combos with lists
Does it show "True" if you set it to "0"?
Charlotte Foust
-----Original Message-----
From: John W. Colby [mailto:jcolby at colbyconsulting.com]
Sent: Tuesday, March 04, 2003 3:45 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] default values for combos with lists
No, I'm saying I set the value to 0 and it was showing me "True".
John W. Colby
Colby Consulting
www.ColbyConsulting.com
----------------------------------------------------------------------------
I've stopped 9,258 spam messages. You can too!
Get your free, safe spam protection at www.cloudmark.com
-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Charlotte Foust
Sent: Tuesday, March 04, 2003 6:36 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] default values for combos with lists
So you're saying you set the default value to = "-1" or -1, and it's
showing you 0?
Charlotte Foust
-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of John W. Colby
Sent: Tuesday, March 04, 2003 3:21 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] default values for combos with lists
Nope, I'm talking about the default value.
Build a combo with two columns, then make -1;True;0;False;*;All as
the list of values.
Place 0 in the default value.
The combo will display True when it opens (or it did with me).
It should display false since the 0 is the false value.
John W. Colby
Colby Consulting
www.ColbyConsulting.com
I've stopped 9,258 spam messages. You can too!
Get your free, safe spam protection at
http://www.cloudmark.com/spamnetsig/
-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Charlotte
Foust
Sent: Tuesday, March 04, 2003 5:38 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] default values for combos with lists
Are you talking about the ItemData, John? That's an index that
relates
to the position.
Charlotte Foust
-----Original Message-----
From: John W. Colby [mailto:jcolby at colbyconsulting.com]
Sent: Tuesday, March 04, 2003 2:27 PM
To: AccessD
Subject: [AccessD] default values for combos with lists
I discovered today that combos that display lists use a default
value
that is the position, not the value of the 1st column. IOW, if a
combo
pulls data from a table, the default value should be a value from
the
leftmost column in the SQL Statement feeding data to the combo. The
value in this column that matches the default value will be
displayed.
This same thing doesn't work for list values, in this case the
number is
the position in the list.
John W. Colby
Colby Consulting
www.ColbyConsulting.com
I've stopped 9,257 spam messages. You can too!
Get your free, safe spam protection at
http://www.cloudmark.com/spamnetsig/
----------------------------------------------------
Is email taking over your day? Manage your time with eMailBoss. Try
it
free! http://www.eMailBoss.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
----------------------------------------------------
Is email taking over your day? Manage your time with eMailBoss.
Try it free! http://www.eMailBoss.com
----------------------------------------------------------------------------
Is email taking over your day? Manage your time with eMailBoss. Try it
free! http://www.eMailBoss.com
----------------------------------------------------------------------------
----
Is email taking over your day? Manage your time with eMailBoss. Try it free!
http://www.eMailBoss.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030304/0633914d/attachment-0001.html>