spam@ifthenelse.com (Greg Silvano - CodeHound.com) wrote:
>On 15 Apr 2000 07:40:09 -0700, "andy" <andy@tcpls.org> wrote:
>
>>
>>I need to search my database by last name and phone and card no. but i

cannot
>>figure out how to set up the search code. I think i need to use select

command.
>>pls help if you can

>
>Yes, you want to use a SELECT statement in SQL. Here's a URL that shows

a tutorial
>on how
>to create a search field in VB for DAO. It's probably a bit more than you

want, but
>I
>think you'd be better off knowing it.
>
>http://www.vbonline.com/vb-mag/conte.../05/ntier2.htm
>
>Basically, you just want to create your database (Access, SQL Server, Oracle,

whatever),
>reference that database in your VB code, create a user interface (UI) for

your users
>to do
>their work with, and get/receive data from the data as needed.
>
>It's not trivial stuff, and is pretty involved if you want to do it right.

It's really
>easy to create a VB/database application that can't handle much pressure.
>
>If you want more data, I got the above link by searching www.codehound.com

for "search
>and
>dao and not ado"...
>
>
>Regards,
>
>Gregory Silvano
>http://www.codehound.com
>Free Internet Search Engine for VB Developers