Quick Search

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I make user databese;
how to simply jump to specific user with buttons A-Z.
Example: if I click to G, I want to program jump to first user whitch
surname started with G.
I have primary key (MatBr) and second column with surname and name.
Thanks!
 
You could place a combo box on the form and in the firls step of the wizard,
check the third choice which reads in part "Find a record..." and bind it to
the surname but have as the source a query of the table with surname and name
as the only field(s) sorted on the surname ascending. Have the combo first
in your tab order. When you begin typing the first letter of the surname it
will select the first name and as you continue to type it will cahnge
accordingly.
Suppose you had Garth, Geer, and Getty as surnames. When "G" (or "g") is
typed, Garth will show. Continue typing the "e" and Geer will show. Type
the following "T" and Getty will show. If you have "Getty, Bob" and "Getty,
Bill", you can contiue typing "ty, Bi" or "ty, Bo" or use the comboboxes pull
down arrow to show all the names that begin with the letters you have typed
and select the desired one.
Hope this helps. Let us know.
Bob
 
Thanks!

„jahoobob via AccessMonster.com“ said:
You could place a combo box on the form and in the firls step of the wizard,
check the third choice which reads in part "Find a record..." and bind it to
the surname but have as the source a query of the table with surname and name
as the only field(s) sorted on the surname ascending. Have the combo first
in your tab order. When you begin typing the first letter of the surname it
will select the first name and as you continue to type it will cahnge
accordingly.
Suppose you had Garth, Geer, and Getty as surnames. When "G" (or "g") is
typed, Garth will show. Continue typing the "e" and Geer will show. Type
the following "T" and Getty will show. If you have "Getty, Bob" and "Getty,
Bill", you can contiue typing "ty, Bi" or "ty, Bo" or use the comboboxes pull
down arrow to show all the names that begin with the letters you have typed
and select the desired one.
Hope this helps. Let us know.
Bob
Click to expand...
 
Back
Top