p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: RE: Searching


Message #1 by "Drew, Ron" <RDrew@B...> on Fri, 28 Jun 2002 07:49:34 -0400
strlastname =3D request.form("yourforminput")   'ne for this example
customer LIKE '" & strlastname & "%'"

Or...
"Select customer From Customers where customer LIKE 'ne%'"

-----Original Message-----
From: Jamaal Sabdul [mailto:jamfl_1999@y...]
Sent: Friday, June 28, 2002 8:37 AM
To: ASP Databases
Subject: [asp_databases] Searching


I am trying to search a data base in access using vb,...i want to be
able
to enter for example "ne*" and return all results that match in a list
box. Does anyone know the coding for that? In access i have a table
called
Customers with say 20 customers that begin with "ne".I want a box that
asks for a name or partial and finds all the names that match the search

criteria and displays results in a box...list or whatever. PLease help.

Message #2 by "Jamaal Sabdul" <jamfl_1999@y...> on Fri, 28 Jun 2002 12:36:42
I am trying to search a data base in access using vb,...i want to be able 
to enter for example "ne*" and return all results that match in a list 
box. Does anyone know the coding for that? In access i have a table called 
Customers with say 20 customers that begin with "ne".I want a box that 
asks for a name or partial and finds all the names that match the search 
criteria and displays results in a box...list or whatever. PLease help.


  Return to Index