Prev: Multi Axis Pivot Chart
Next: Template help - The pimping continues
From: David W. Fenton on 28 Feb 2010 21:31
i dude eclair <br25354(a)aol.co.uk> wrote in
news:Xns9D2B7BB3AC50Ejoekingaolcouk(a)74.209.136.86:

> my client wants an application to behave like this website:
>
> http://ericshin.com/orchestrations.php
>
> I would think that access would be the ideal application.

It's much more difficult on a web page than in Access.

> Any direction to get me started would be greatly appreciated.

Your looking for discussions of filtering combo boxes, or synching
combo boxes (maybe "cascading"). The techniques are the same for
combo boxes and listboxes. It's a matter of using the AfterUpdate
event of the first listbox to either set the rowsource of the second
or requery it (if the rowsource has the first listbox hardwired into
its criteria). Then the AfterUpdate even of the second does the same
for the third.

It's really that simple, though there are a number of niceties that
will be required (like clearing/requerying the 3rd listbox when the
first is updated and such).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
From: i dude eclair on 3 Mar 2010 18:32
"David W. Fenton" <XXXusenet(a)dfenton.com.invalid> wrote in
news:Xns9D2DDAEE6C3B6f99a49ed1d0c49c5bbb2(a)74.209.136.100:

> i dude eclair <br25354(a)aol.co.uk> wrote in
> news:Xns9D2B7BB3AC50Ejoekingaolcouk(a)74.209.136.86:
>
>> my client wants an application to behave like this website:
>>
>> http://ericshin.com/orchestrations.php
>>
>> I would think that access would be the ideal application.
>
> It's much more difficult on a web page than in Access.
>
>> Any direction to get me started would be greatly appreciated.
>
> Your looking for discussions of filtering combo boxes, or synching
> combo boxes (maybe "cascading"). The techniques are the same for
> combo boxes and listboxes. It's a matter of using the AfterUpdate
> event of the first listbox to either set the rowsource of the second
> or requery it (if the rowsource has the first listbox hardwired into
> its criteria). Then the AfterUpdate even of the second does the same
> for the third.
>
> It's really that simple, though there are a number of niceties that
> will be required (like clearing/requerying the 3rd listbox when the
> first is updated and such).
>

thank you
that is a great start

muchly appreciated
From: i dude eclair on 8 Mar 2010 10:30
> Your looking for discussions of filtering combo boxes, or synching
> combo boxes (maybe "cascading"). The techniques are the same for
> combo boxes and listboxes. It's a matter of using the AfterUpdate
> event of the first listbox to either set the rowsource of the second
> or requery it (if the rowsource has the first listbox hardwired into
> its criteria). Then the AfterUpdate even of the second does the same
> for the third.
>
> It's really that simple, though there are a number of niceties that
> will be required (like clearing/requerying the 3rd listbox when the
> first is updated and such).
>

do you know of any known examples of this, so that I can look at the code?
I haven't found any in Northwind ...

tks
From: ʦ��ϼ on 9 Mar 2010 22:33

"i dude eclair" <br25354(a)aol.co.uk> д����Ϣ����:Xns9D356ACB27449joekingaolcouk(a)74.209.136.87...
>> Your looking for discussions of filtering combo boxes, or synching
>> combo boxes (maybe "cascading"). The techniques are the same for
>> combo boxes and listboxes. It's a matter of using the AfterUpdate
>> event of the first listbox to either set the rowsource of the second
>> or requery it (if the rowsource has the first listbox hardwired into
>> its criteria). Then the AfterUpdate even of the second does the same
>> for the third.
>>
>> It's really that simple, though there are a number of niceties that
>> will be required (like clearing/requerying the 3rd listbox when the
>> first is updated and such).
>>
>
> do you know of any known examples of this, so that I can look at the code?
> I haven't found any in Northwind ...
>
> tks


From: De Jager on 13 Mar 2010 12:47

"i dude eclair" <br25354(a)aol.co.uk> wrote in message
news:Xns9D30BCAADF4C3joekingaolcouk(a)74.209.136.87...
> "David W. Fenton" <XXXusenet(a)dfenton.com.invalid> wrote in
> news:Xns9D2DDAEE6C3B6f99a49ed1d0c49c5bbb2(a)74.209.136.100:
>
>> i dude eclair <br25354(a)aol.co.uk> wrote in
>> news:Xns9D2B7BB3AC50Ejoekingaolcouk(a)74.209.136.86:
>>
>>> my client wants an application to behave like this website:
>>>
>>> http://ericshin.com/orchestrations.php
>>>
>>> I would think that access would be the ideal application.
>>
>> It's much more difficult on a web page than in Access.
>>
>>> Any direction to get me started would be greatly appreciated.
>>
>> Your looking for discussions of filtering combo boxes, or synching
>> combo boxes (maybe "cascading"). The techniques are the same for
>> combo boxes and listboxes. It's a matter of using the AfterUpdate
>> event of the first listbox to either set the rowsource of the second
>> or requery it (if the rowsource has the first listbox hardwired into
>> its criteria). Then the AfterUpdate even of the second does the same
>> for the third.
>>
>> It's really that simple, though there are a number of niceties that
>> will be required (like clearing/requerying the 3rd listbox when the
>> first is updated and such).
>>
>
> thank you
> that is a great start
>
> muchly appreciated

First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Multi Axis Pivot Chart
Next: Template help - The pimping continues