combo box does not full fill need.

Question

Hi Experts,

I have a table name item.dbf having 35000 records. I let user select item from item.dbf. Combo does not full fill my requirment as in combo if user press fast key strokes then item get selected and if user slowly presses key strokes it does not work. I want selecting items from table like vfp help selects the help topics from the list as we press "a" ,items starting from "a" lists, pressing "as" items starting from "as" lists. Can anybody tell me any function to do this.
Thanks.

Answer 1

You may try to replace combo with a grid, there are to many records.

---

dni

Answer 2

You need to rethink your UI. Don't provide all the records to the user. Instead provide a query form. The user enters Smith into the textbox then clicks the Find button. Only records for Smith are returned. You now have a more managable list that can be displayed in a grid.

---

Craig Berntson MCSD, Visual FoxPro MVP www.craigberntson.com

Answer 3

Using query form, if user misspelt, item will not be located. I want to do this exactly as vfp help index tab works. Can I do this with a combo.
Thanks

Answer 4

This is example of Multi Column Combo with Incremental and various type of Search and combination of grid & combobox..

http://www.universalthread.com/Downloads/SpecialCombo.zip

http://www.tek-tips.com/viewthread.cfm?qid=850149&page=62

---

Please "Mark as Answer" if this post answered your question. :)

Kalpesh Chhatrala | Software Developer | Rajkot | India

Kalpesh's Blog

Answer 5

Thanks Kalpesh

I have another question. Following is my code to call a form 'batchfrm' from a form 'itmfrm'

PRIVATE cCodeName,alistk,recstk
CREATE VIEW denvstk
SAVE to mvstk
STORE ALIAS() TO alistk
STORE RECNO() TO recstk
CLOSE DATABASES
do FORM batchfrm WITH cCodeName
SET VIEW TO denvstk   
ERASE denvstk.vue   
RESTORE FROM mvstk.mem ADDITIVE
ERASE  mvstk.mem
SELECT &alistk
COUNT
IF _tally#0 &&recc()#0
GO recstk
ENDIF

In above code all the code runs atonce while after releasing batchfrm, next commands should run.

Please tell me the solution.

Thanks

Answer 6

if you want to execute next command after releaseing batchfrm

you have to make batchfrm as modal form..

---

Please "Mark as Answer" if this post answered your question. :)

Kalpesh Chhatrala | Software Developer | Rajkot | India

Kalpesh's Blog

Answer 7

if you want to execute next command after releaseing batchfrm

you have to make batchfrm as modal form..

---

Please "Mark as Answer" if this post answered your question. :)

Kalpesh Chhatrala | Software Developer | Rajkot | India

Kalpesh's Blog

Thanks Kalpesh

Answer 8

This question is on a different topic than the first. Next time, please start a new thread.

---

Craig Berntson MCSD, Visual FoxPro MVP www.craigberntson.com

Answer 9

Combo box was not designed to hold that many items. It's too slow and too difficult to use. Additionally, you need to pull all the data back, which is not optimal and has performance issues, increases network bandwidth, etc. Rethink the query form. The user doesn't have to enter the complete name. If you structure the query correctly, they can enter any part of the name and make it work.

---

Craig Berntson MCSD, Visual FoxPro MVP www.craigberntson.com

Answer 10

Combo box was not designed to hold that many items. It's too slow and too difficult to use. Additionally, you need to pull all the data back, which is not optimal and has performance issues, increases network bandwidth, etc. Rethink the query form. The user doesn't have to enter the complete name. If you structure the query correctly, they can enter any part of the name and make it work.

---

Craig Berntson MCSD, Visual FoxPro MVP www.craigberntson.com

Thanks Berntson

Can you give me some samle code what you are saying. I need axactly vfp help index tab works.

Typing a word, items in the list is sorted in that order. I am not understanding how to start it.