John W. Colby
jcolby at colbyconsulting.com
Tue Mar 4 20:50:00 CST 2003
MessageGoing into edit mode is not the same as closing the form. Edit mode
keeps the last state of the form. This includes record selected, filters
etc. Closing the form gets rid of this "last state" (usually).
John W. Colby
Colby Consulting
www.ColbyConsulting.com
----------------------------------------------------------------------------
----
I've stopped 9,263 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 Bruce Bruen
Sent: Tuesday, March 04, 2003 9:37 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] default values for combos with lists
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 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
---
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
----------------------------------------------------------------------------
----
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/4610fcb3/attachment-0001.html>