[dba-SQLServer]Clear Selections in a ListBox

Thanks.  Just what I was looking for.

-----Original Message-----
From: Mike and Doris Manning [mailto:mikedorism at ntelos.net] 
Sent: Monday, March 24, 2003 1:23 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]Clear Selections in a ListBox


If you want to save Server/Client resources, you could loop through the
listbox and set the SELECTED property of each item to False.  The
example below will work in Access 2000.

Dim lcv as Integer

If Me.Listbox.ItemsSelected.Count > 0 Then
   For lcv = 0 to Me.Listbox.ListCount - 1
      If Me.Listbox.Selected(lcv) = True then Me.Listbox.Selected(lcv) =
False
   Next lcv
End If

Note:  If you have header rows turned on, then you will need to start
the count at 1.

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan
Zeller
Sent: Monday, March 24, 2003 02:11 PM
To: dba-SQLServer at databaseadvisors.com
Subject: [dba-SQLServer]Clear Selections in a ListBox


In a multiselect listbox, what is the best way to clear selections user
has made.  The recordsource for the listbox is a stored procedure so
what I have been doing is on click of a clear list button, I reset the
rowsource of the listbox as in:  

Me.listbox.rowsource = "exec dbo.MySprocName '" & strMyParamter & "'"

Is this the best way?  Or, should I somehow be looping through the
records to see which items are selected and then unselect them?

--Susan


Susan B. Zeller
Office of Information Systems
College of Continuing Education
University of Minnesota
306 Wesbrook Hall
77 Pleasant Street SE
Minneapolis, MN 55455
Phone:  612-626-4785
Fax:  612-625-2568


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com