[AccessD] default values for combos with lists

Bruce Bruen bbruen at bigpond.com
Tue Mar 4 20:39:01 CST 2003


How very interesting.  BUT.... when I first opened the form it did show
False, then I selected True, closed (well went into edit mode) and
reopened it and it showed True. The same thing happened when All was
selected.
So I guess it has something to do with the itemselected
thingodoodyattribute???
 
hth 
Bruce

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of John W. Colby
Sent: Wednesday, March 05, 2003 10:45 AM
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 HYPERLINK
"http://www.cloudmark.com/spamnet?v1"www.cloudmark.com
HYPERLINK "http://www.cloudmark.com/"Cloudmark SpamNet - Join the fight
against spam!


-----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 [HYPERLINK
"mailto:accessd-admin at databaseadvisors.com"mailto:accessd-admin at database
advisors.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 
HYPERLINK "file://www.ColbyConsulting.com"www.ColbyConsulting.com 


	I've stopped 9,258 spam messages. You can too! 
Get your free, safe spam protection at HYPERLINK
"http://www.cloudmark.com/spamnetsig/"http://www.cloudmark.com/spamnetsi
g/ 

	-----Original Message----- 
From: accessd-admin at databaseadvisors.com 
[HYPERLINK
"mailto:accessd-admin at databaseadvisors.com]On"mailto:accessd-admin at datab
aseadvisors.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 [HYPERLINK
"mailto:jcolby at colbyconsulting.com"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 
HYPERLINK "file://www.ColbyConsulting.com"www.ColbyConsulting.com 


	I've stopped 9,257 spam messages. You can too! 
Get your free, safe spam protection at 
HYPERLINK
"http://www.cloudmark.com/spamnetsig/"http://www.cloudmark.com/spamnetsi
g/ 

	---------------------------------------------------- 
Is email taking over your day?  Manage your time with eMailBoss. Try it 
free!  HYPERLINK "http://www.eMailBoss.com"http://www.eMailBoss.com 


	_______________________________________________ 
AccessD mailing list 
AccessD at databaseadvisors.com 
HYPERLINK
"http://databaseadvisors.com/mailman/listinfo/accessd"http://databaseadv
isors.com/mailman/listinfo/accessd 
Website: HYPERLINK
"http://www.databaseadvisors.com"http://www.databaseadvisors.com 
_______________________________________________ 
AccessD mailing list 
AccessD at databaseadvisors.com 
HYPERLINK
"http://databaseadvisors.com/mailman/listinfo/accessd"http://databaseadv
isors.com/mailman/listinfo/accessd 
Website: HYPERLINK
"http://www.databaseadvisors.com"http://www.databaseadvisors.com 



	---------------------------------------------------- 
Is email taking over your day?  Manage your time with eMailBoss.  
Try it free!  HYPERLINK
"http://www.eMailBoss.com"http://www.eMailBoss.com 

   _____  

Is email taking over your day? Manage your time with eMailBoss. Try it
free! HYPERLINK "http://www.eMailBoss.com"http://www.eMailBoss.com


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.445 / Virus Database: 250 - Release Date: 21/01/2003



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.445 / Virus Database: 250 - Release Date: 21/01/2003
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030304/4aa2255e/attachment-0001.html>


More information about the AccessD mailing list