Incremental search in DBGrid & End printing 
Author Message
 Incremental search in DBGrid & End printing

1.I need to give the user the capability to enter data in a text box an as
he does so each key stroke narrows the search on a DBGrid showing info in
the first column and the highlight moves to the appropriate row as the
search narrows( which is the index of the underlying data table.)
I've see  lots on these searches for lists and combo boxes but nothing on
DBGrids
2. What method is used to halt printing with a Cancel when multiple copies
are sent to the printer but you change your mind once printing starts
(Crystal Reports is the OCX used.Data is spooled in Win95)
TIA  



Fri, 26 May 2000 03:00:00 GMT  
 Incremental search in DBGrid & End printing


Quote:
>1.I need to give the user the capability to enter data in a text box an as
>he does so each key stroke narrows the search on a DBGrid showing info in
>the first column and the highlight moves to the appropriate row as the
>search narrows( which is the index of the underlying data table.)
>I've see  lots on these searches for lists and combo boxes but nothing on
>DBGrids

I just worked throught this myself.

In the On_Change event code of the text box, use a seek on the
recordset behind the DBGrid.  The recordset has to be of the Table
type.

    Data1.Recordset.Index = "Main"
    Data1.Recordset.MoveFirst
    Data1.Recordset.Seek ">=", PosToPart

PosToPart is the Text Box, Data1 is the Data Control.

Hope this helps.

Shawn



Fri, 26 May 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Incremental search

2. HELP....Textbox for incremental search.

3. Incremental Search on a dbCombo or dbList

4. Incremental Search

5. Incremental Search (as in VB Help)

6. howto incremental search in datacombo listbox?

7. List Box incremental search.

8. Using an Incremental Search List Box!

9. Incremental Search List

10. HELP: Combo Box Incremental Search

11. Incremental search combo box

12. Incremental search of Outline control

 

 
Powered by phpBB® Forum Software