|
|
Search list box form text box
I hope I am in the right place. I found this site looking for a solution on
google. I am working with Access 2007.
I have an application I'm working on that requires a list box for selection.
OK. I can do that. I am working with a customers table and for simplicity
we'll say it has an auto number field, last name, first name, and ss # field.
I have created a list box, and I can highlight a record and select it for
editing.
The problem is that as this database grows, I would like to have a text box
where the user can search by last name or ss # and it would go to and
highlight the first record matching their criteria in the list box as they
typed. They would still use the list box for the record selection, but this
would help them find a record in the middle very quickly without scrolling.
I would either use buttons or radio buttons for the selection type (last
name or ss #).
I need the record in the list box to have focus as they type. I can't find
any examples anywhere for this.
Hope I'm not over my head.
|
|
0
|
|
|
|
Reply
|
 Utf
|
1/2/2010 1:29:01 AM |
|
Hi wlhj,
You could have a command button on the form where the click event includes
code to grab the value you type in the text box, as long as it is not null,
ie.:
If Len(TextboxName & "") > 0 Then
and then uses this in the WHERE clause of a SQL statement to change the Row
Source for your list box. Take a look at this article:
Access Cookbook: Chapter 8 Excerpt: Make Slow Forms Run Faster
http://msdn.microsoft.com/en-us/library/aa188218(office.10).aspx
Scroll down to the section sub-titled "Combo and list box controls", about
1/3 of the way down.
> I need the record in the list box to have focus as they type. I can't find
> any examples anywhere for this.
Do you really need this? Only one control can have focus at a time, so the
text box that one is entering data into has the focus.
Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
"wlhj@news.postalias" wrote:
> I hope I am in the right place. I found this site looking for a solution on
> google. I am working with Access 2007.
>
> I have an application I'm working on that requires a list box for selection.
> OK. I can do that. I am working with a customers table and for simplicity
> we'll say it has an auto number field, last name, first name, and ss # field.
> I have created a list box, and I can highlight a record and select it for
> editing.
>
> The problem is that as this database grows, I would like to have a text box
> where the user can search by last name or ss # and it would go to and
> highlight the first record matching their criteria in the list box as they
> typed. They would still use the list box for the record selection, but this
> would help them find a record in the middle very quickly without scrolling.
>
> I would either use buttons or radio buttons for the selection type (last
> name or ss #).
>
> I need the record in the list box to have focus as they type. I can't find
> any examples anywhere for this.
>
> Hope I'm not over my head.
|
|
|
0
|
|
|
|
Reply
|
Utf
|
1/2/2010 1:43:01 AM
|
|
|
1 Replies
561 Views
(page loaded in 0.062 seconds)
Similiar Articles: Find Text in List Box - microsoft.public.access.formsI've looked hi and lo for code to find text in a List Box using the Find input box in AC 2007. Finding text in the form works ok but finding it in a L... Ignore predictive text in a search combo box - microsoft.public ...Find Text in List Box - microsoft.public.access.forms Ignore predictive text in a search combo box - microsoft.public ... Auto Update Text box - microsoft.public.access ... how can i search records with a text box? - microsoft.public ...Hello, what im looking to do is have a text box where the user can enter a number ( number is based off a spread sheet, which is already in a table )... Multiselect List Box - microsoft.public.access.formsI'm trying to modify Allen Browne's Search form to use a multiselect list box, but my ... and " > End If > > > 'Another text field example. Use Like to find ... Save values displayed in unbound text fields from combo box to tab ...I have a form called “daily patient info” which has bound list box controls and text boxes. I also have an unbound combo box named combo box 111 T... Multiple items in text box on a form? - microsoft.public.access ...I want a text box to display items from a table and text together? so the MainTable collects quantity, color and price which is enter through antother form. List Box Selection - microsoft.public.access.formsI have a standard list box on a form, bound to a query, which shows several hundred names ... Note that the Text property of a text box is only valid while the text box has ... Form Objects Disappear When Filter Returns No Records - microsoft ...AC 2007 sp2. I have a form with a list box combo box and a text box. The cbo is used to filter records in the form and is also synced with the li... list box field printing black in forms and reports - microsoft ...I've set up both forms and reports containing field that have a drop down list box. The box shows up black and the text is white, however when I pri... Can't change the Back Color of my List Box - microsoft.public ...Perhaps you should start a new form and see what happens then (and don't convert a Text box to a List box just in case that is the problem). Perhas someone else has ... Search list box form text box DataBase - DataBase Discussion List ...I hope I am in the right place. I found this site looking for a solution on google. I am working with Access 2007. I have an application I am working o Making a Searching List Box in Access 2007Summary: Learn how to create a search list box by using a text box ... Create a new form in your database that contains at least a text box and a list box. Add a list box or combo box to a worksheet - Excel - Office.comLearn about list boxes and combo boxes. List box Displays a list of one or more items of text from ... For example, a dessert preference form has a list box that is ... Search a list box while typing in a text box in Winforms C#LINQ Windows Forms Miscellaneous Advertising, Marketing, SEO SQL Server ... items are loaded from database , when user types anything in text-box, list-box should search the ... Basic Forms | basic inputs: , text-input boxes, radio buttons and ...Form Structure | Text Boxes · One-line Text Box · Text Area Box | Selection Boxes · Radio Buttons · Check ... name="firstname", because you were using this box to find out the ... 7/18/2012 2:36:30 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
31 followers. 