Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB How-To
|
VB How-To Ask your "How do I do this with VB?" questions in this forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB How-To section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 4th, 2006, 01:19 PM
Registered User
 
Join Date: May 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Search for a client in a table

I am trying to search for a client in one of my tables by using something like a Data grid or a look like this that the user could type in a couple of letters from the last name and get a list of the clients and pick the one that they want. When they pick the one that they want it will come up on a form where they can update the information.

I am a newbie to Visual Basic and would appreciate any help that anyone could give me or point me in a direction that would accomplish this task.

Thanks in advance for your help.

 
Old May 5th, 2006, 10:59 AM
Friend of Wrox
 
Join Date: Nov 2004
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts
Default

If you set a ComboBox to that field, then as the user types in the box the box will do "quick lookup," jumping to the first entry in the list that matches the letters typed so far.
You should be able to use the box’s on change or on update events to perform the actions you need after a selection has been made.
 
Old May 5th, 2006, 01:16 PM
Registered User
 
Join Date: May 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Cool!! I was hoping that something like that would work but hadn't went in that direction yet. Thanks so much for you help. I will let you know the outcome when I get it working.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Query to Search for a value in a table Vendirella SQL Language 0 October 10th, 2007 12:47 AM
search table? bmurty Access VBA 1 September 21st, 2005 06:51 AM
search a table which has a apostrophe in it crmpicco MySQL 2 August 10th, 2005 06:23 AM
Linked Table working very slow with client program Nerijus Access 0 July 7th, 2003 08:34 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.