[AccessD] List Boxes

Rocky Smolin rockysmolin at bchacc.com
Wed Dec 15 12:23:14 CST 2010


Tony:
Awkward but can you clear the row source of the other list boxes and only
populate the row source though code when needed?

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav
Sent: Wednesday, December 15, 2010 10:02 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] List Boxes

Hey Lambert
Thank you for your response.
Tried the Enabled, but what happens is the originating list box goes blank
while the requerying is going on. Works but the blank is annoying. 
I had previously tried Locked but it causes the list box to display multiple
highlights (as I click) until I go back a list box and then requery.

Heenan, Lambert wrote:

>In the code that kicks off the requery you could probably first loop though
all the listboxes and sent their enabled property to False.
>
>Pseudo-code
>
>	For Each ListBox In Me
>		ListBox.Enable=False
>	Next ListBox
>	Requery
>	For Each ListBox In Me
>		ListBox.Enable=True
>	Next ListBox
>
>Lambert
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com 
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav
>Sent: Wednesday, December 15, 2010 11:41 AM
>To: Access Developers discussion and problem solving
>Subject: [AccessD] List Boxes
>
>Hey All
>I have a series of 9 list boxes on a form. Sort of a drill down, the 
>user selects an item in a list box and it then displays (waterfalls) 
>the results in the following list boxes. For 60,000 records it takes 
>about
>2  to 3 seconds to refresh/requery all the list boxes.  One thing I don't
quite understand is why when I manually open a query used for a list box it
is quite fast, but when the list box gets requeried on the form there is
noticable time lag. I can live with the 2 to 3 second delay time but what I
am finding is as the program  requeries the other list boxes I can click on
the originating list box  and I get the error message "The macro or function
set to the BeforeUpate or ValidationRule......" .  The only event on the
list box is an On Click. 
>I have tried several approaches to try and prevent the user clicking before
all requeries are completed. Is there a way to disable the cursor while  the
code is running??
>--
>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