FIND RECORD IN FORM

[Nip Lewis]

I have a form set up for voter information and set up using action of findind a voter through query by form.

If I lookup a name such a Smith I get all the Smiths, but when I try to look up Lewis, it will not find Lewis. I found I had to go back to main table and use Query to show all arrange them in alpha order and then go to the form and search for the next name.

Question: Is there a way to say in the form and search for many different names you want to make changes on or do you have to resort to this operation?

Any help would be appreciated.

Nip Lewis

[Ken L Herrold]

RE: FIND RECORD IN FORM

Nip:

I have a button on my form called 'Find' with this script attached.
___________
dim global job as c
parentform.index_set("Name")
job = ui_get_text( "Who Ya Lookin' For?", "",job)
IF job = ""
END
END IF
parent.find(job)
end
_______________
second line sets the index to last name
UI gets the name
parent.find(job) takes you to the record.
Unlike the query by form, there's no need for the 'show all'

The index set puts the table in that index and it' still active when the operation is over.

Is this maybe what you want?

Ken

[CALocklin]

RE: FIND RECORD IN FORM

I'm not sure why it is acting that way. I just went to a client table and did a query-by-form on one name (38 matches found) then simply started another query-by-form on a different name and it worked fine (11 found).

Is it possible that either "Lewis" is really " Lewis" with a leading blank space or that Lewis doesn't exist?

Also, my preference is to use an index such as:
trim( last_name ) + " " + first_name

Then create a Find button that sets this index (in case it hasn't already been set) and starts a Find-by-key operation that prompts the user for a name. This allows the user to type "smith j" to locate the first Smith whose first name starts with a "J" and they can PageDown from there if necessary. Of course, they could also type the complete first name to be more specific.

I prefer this method for two reasons: (1) I think it's easier for most users and (2) it's faster than a query - especially on large tables.

[CALocklin]

RE: FIND RECORD IN FORM

Apparently Ken and I were typing at the same time. My idea is the same as Ken's except I prefer the index with last name AND first name. (With a space between them)

[Nip Lewis]

RE: FIND RECORD IN FORM

hI cAL
Your suggestion worked fine. Thank you very much. I tried Trim(name) as I have the entire name in that field called name.

I created another table called 10Septvtr and tried your suggestion, but it did not work. It has the same Name field, but it does not index properly. Is this because I am in the same control panel?

Any help would be appreciated.

Thanks again.

Nip Lewis

[Tom Cone Jr]

RE: FIND RECORD IN FORM

Nip,

I'm not sure your table name can begin with anything other than a letter.

-- tom

[Ken L Herrold]

RE: FIND RECORD IN FORM

NIP and guys....

If the name field holds the ENTIRE name, is a data-entry convention in place that would be i.e. 'Last'[space or comma]'first' throughout the table? Not a good idea if it is structured that way -- causes these kinds of problems down the road when you try to find or filter.

Consider splitting out the last and first names to seperate fields.

In Cal's example, maybe alltrim() would be better to remove an inadvertant blank space in front of the name and behind it. As in the ' Lewis' debauchle example, Cal suggests.

Just some more thoughts

Ken