Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Search and display
Message
From
12/02/2002 17:31:50
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Search and display
Miscellaneous
Thread ID:
00619196
Message ID:
00619196
Views:
68
I have a form with a grid that displays names and addresses. When users take a call they need to see if the person calling already has an existing record. The company will not use id# so we search by name. I have an index namekey that is comprised of lastname and firstname. I have a textbox on the form. When a call is taken the user enters the name in the textbox. In theory as a name is entered the pointer should move to the closet record. I have the keypress for the textbox set as follows.

I have 2 issues. First, the grid seems to react to only every second keystroke.

Second, is there a way to change the display font (or some other form of highliting) only on the record that is the closet match to the keystrokes that have been entered to this point.

In other words I would like the closest match to be in the center of the grid and displayed in some manner that will bring attention to that record.

KEYPRESS

LPARAMETERS nKeyCode, nShiftAltCtrl

set talk off
set near on
local addnew
select members
set order to tag namekey
addnew=alltrim(thisform.add1.value)
seek (addnew)
thisform.new.visible=.T.
thisform.grid1.refresh


Thanks
Dennis
Next
Reply
Map
View

Click here to load this message in the networking platform