ComboBox 7

[StewartUK]

Hi,

I have a ComboBox which I want to use to select codes. The RowSourceType is 2-Alias, with nothing in the RowSource property. In the form's Init event, I have selected all the records from the codebook into a cursor, and put the cursor name into the RowSource.

What I would like to be able to do is as the user types characters, the ComboBox selects into the cursor records that match what the user has typed.

Any suggestions?

Thanks,

Stewart

 

[ramani]

After putting the cursor name in the rowsource in the init event..
add the code..
This.Style = 2 && DropDown List
This shall bring you the feature you want. ramani :-9
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[StewartUK]

Thanks Ramani, that did it.

It's still a bit clunky though.

What I did was to select records where the characters typed appeared anywhere in the code description.

When I type a second character, the active item marker (if that's the right wording?) moves down to the item beginning with that second character or, if there is no item beginning with that 2nd character, it leaves the box above the list empty.

Is there a way around this do you know? What if I put in NO DEFAULT somewhere?

Thanks,

Stewart

 

[Mike Gagnon]

I have an example of an Incremental search combo that automaticaly shows the found record and if you are at the second letter and if it found a record it will show the remaining letters in blue, but if it didn't find a match, it will only leave the two caracters you typed. If you are interested send me an e-mail.

 

[StewartUK]

mgagnon,

That sounds interesting. Could you email it to me (I don't know your email address).

Thanks,

Stewart
scoombs@feba.org.uk

 

[Mike Gagnon]

I just sent it to you. Most of the code is in the InteractiveChange

 

[Scott24x7]

Mgagnon...
Could I inqure to ask if I may please have that class as well??? (I'll beg, if need be...)

email: scottvpayton@hotmail.com

Best Regards,
Scott

Please let me know if this has helped

 

[VFP602]

Mgagnon,
Could I also be included in your list? Pls. send your class to bongrobles@yahoo.com. Thanks in advance.

 

[oli974]

and if i don't abuse, i'm here too, just in the corner !!
at o_bricotte@hotmail.com
thx for all

 

[german12]

Your program ist even requested in Germany - would like to thank you.
...and of course would like to help you in case that there is something to be translated from
german into english (as best as I can...)
My address:

KBriesemeister@t-online.de

Regards
Klaus

 

[Mike Gagnon]

[red]
Your program ist even requested in Germany - would like to thank you.
...and of course would like to help you in case that there is something to be translated from
german into english (as best as I can...)
My address:

KBriesemeister@t-online.de

Regards
Klaus
[/red]

Thank you Klaus, I may just take you up on this offer one day.

 

[gluckmac]

Mgagnon,

Please send a copy of your code to cgluckman@yahoo.com. One of my forms has a combo box that displays over 500 items and the only way to select a specific item is to scroll down the list.

My client, to say the least, wants to be able to select the desired item with a few key strokes.

Thanks.

Charles

 

[Mike Gagnon]

It's on it's way, you may also consider an array or a cursor, to speed-up things, if the record count will increase in the future, although I've use this combo with 45,000 records with no problems.

 

[Guest_imported]

mgagnon,

Please send me a copy too(leongtk@yahoo.com)!

(Note: anyone who have the code please send to me, just in case mgagnon didn't seen this message)

Thanks in advance!

 

[wgcs]

Sounds like someone who has this code should make a FAQ!

 

[Mike Gagnon]

Yes it would be nice to post it in FAQ, but aside from the code in the interactiveChange, there are a couple of properties to a to the comboclass, it a little hard to explain in an FAQ.

 

[Mike Gagnon]

For anyone interested in this "auto-fill" (Like Quickens or Internet Explorer) style combobox, I just posted the code in the FAQ (faq184-1792)

 

[pxw]

Can I place more than one star on a thread? I tried to give five stars to mgagon. It doesn't work.

Peter

 

[pxw]

hi mgagnon,

thnx for your class. I will try it shortly.

Your class is likely very useful. I have been asked to do so in the past a few years. However, I gave up finally after tried many times. I am using dropdown list in my applications. I would give myself five stars if I can solve this problem.


Peter

 

[BlindPete]

Hey can I have that class too?

I've always been a joiner not a leader!

blindpete@netzero.net
-Pete