[AccessD] Sorting and restricting ComboBox on ListBox content s

DWUTKA at marlow.com DWUTKA at marlow.com
Thu Apr 15 16:04:29 CDT 2004


Well, Access doesn't necessarily 'store' the information the way that you
see it.  So you will need some field to 'sort/group' by.  For instance, if
you want the 'highest' ID, then GroupBy CourseName and set Max for the ID.  

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Hewson
Sent: Thursday, April 15, 2004 3:45 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Sorting and restricting ComboBox on ListBox
contents


My error.  I only need one.
Thanks for noticing.
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
DWUTKA at marlow.com
Sent: Thursday, April 15, 2004 3:45 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Sorting and restricting ComboBox on ListBox
contents


In the section that you 'want', what is the difference between DSC M and DSC
M?  Why would you want 2, when you have 1 of everything else?

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Hewson
Sent: Thursday, April 15, 2004 2:53 PM
To: AccessD
Subject: [AccessD] Sorting and restricting ComboBox on ListBox contents



I am having difficulty figuring this one out.

A97.  
I have a list box with over 130 items all rows are distinct but a few
columns are duplicates.  The ListBox is sorted on two text fields which puts
the ID number out of sequence.  The ComboBox sorts and "Groups By" duplicate
columns.  What I want to do is use the ComboBox to jump to the first
instance of one of the duplicate columns.

e.g.

ID	CourseName	City
135	CCP		EC
90	DIS		EC
87	DIS		MP
18	DOC		CD
17	DOC		SR
55	DSC M		AL
57	DSC M		EC
43	DSC M		MP
28	DSC M		SF
3	DSC M		SR

What I want is:
135	CCP		EC
90	DIS		EC
18	DOC		CD
55	DSC M		AL
3	DSC M		SR

What I get is:
135	CCP		EC
87	DIS		MP
17	DOC		SR
3	DSC M		SR

What needs to be done to what the desired results?

Thanks,

Jim 
-- 
_______________________________________________
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



More information about the AccessD mailing list