A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Multiple listbox questions



 
 
Thread Tools Display Modes
  #1  
Old March 19th, 2010, 04:01 PM posted to microsoft.public.access
Robbro
external usenet poster
 
Posts: 82
Default Multiple listbox questions

I have a sales/cost/profitability report that with lots of help from posters
here I have managed to create a form to filter it by several criteria and its
all working well, I'm just tweaking it some now and have a few questions:

First I have 2 listboxes 1 for customers (we currently have 346 listed), 1
for lots (we currently have 663 listed). On both of them (both multiselect)
the slider does not work quiet right. On first load if you drag the slider
all the way to the bottom, it only goes down about half the list, release the
mouse button and the slider appears mid way down instead of at bottom where
you left it, then you can drag it the rest of the way, I assume its because
we have so many items in both boxes. Its definitely not a big deal but would
be handy to resolve this.

Second I have a start date and end date filter by drop down boxes and then
check boxes for each of our plants to filter by. I have added after update
events to update our 2 long listboxes described above with the following code
in both:

SELECT sales.Customer FROM sales WHERE (((sales!Plant) In
([plant1]*-1,[plant2]*-2,[plant3]*-3,[plant5]*-5,[plant81]*-81)) And
((sales![Month End]) Between [StartDate] And [EndDate])) GROUP BY
sales.Customer ORDER BY sales.Customer;

After adding the above loading the form slowed considerably, again I realize
I'm dealing with a lot of info, but am I doing it in an ineffecient way?

Finally I considered having 1 listbox update the options on the other
listbox but fear that would make things extremely slow, and possibly even
going both ways, as you update 1 list box the other one updates its available
options if thats even possible. Would that be unadvisable?

Thanks
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.