Article View: alt.comp.databases.xbase.clipper
Article #16Re: search function
From: Brent R Brian
Date: Tue, 28 Sep 1999 00:00
Date: Tue, 28 Sep 1999 00:00
51 lines
2978 bytes
2978 bytes
under ms-access: select * where my_column like '%xxxx%' if I am not mistaken, the %xxx% may be a bit off, but there are wildcard characters that will need to surround the "search item", or not if an exact match is desired. I you need an example, I may still have one at the house, somewhere, ..... B Peter wrote: > > sorry > the user will be able to search on multiple columns, but only one at a time. > so, the search will only be on one column. > > Peter wrote: > > > It will be multiple columns. > > I have a fair idea about how to go about it, but Im not very familiar with VB > > yet. > > > > thanks > > > > Brent R Brian wrote: > > > > > Are you wanting to search a single column, or multiple columns ?? > > > > > > B > > > > > > Peter Strong wrote: > > > > > > > > hello > > > > > > > > Im trying to do a search function (in MS ACESS) from a form that searches > > > > for and returns values (either to a form, or in datasheet view) that either > > > > matches or partly matches a search string. > > > > > > > > The search string will be input into a text box and when a button (submit > > > > search details) is clicked the results will be displayed. > > > > > > > > If anyone could help me as to how to tackle this problem, or what functions > > > > I should use, it would be greatly appreciated. > > > > > > > > thankyou > > > > > > > > Peter Strong
Technical Details
Message-ID:
<37F0E2F2.D4D03BCF@prodigy.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<7so02k$nau$1@bunyip.cc.uq.edu.au> <37EF8D80.2FC8B2EC@prodigy.net> <37F00D1E.6127A629@student.uq.edu.au> <37F0260D.307A45AA@student.uq.edu.au>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: f469f,1aaba471388bd669 X-Google-Attributes: gidf469f,public X-Google-Thread: 10b2b7,1aaba471388bd669 X-Google-Attributes: gid10b2b7,public X-Google-Thread: ff0ac,1aaba471388bd669 X-Google-Attributes: gidff0ac,public X-Google-Thread: fc5c9,1aaba471388bd669 X-Google-Attributes: gidfc5c9,public X-Google-Thread: 106b3c,1aaba471388bd669 X-Google-Attributes: gid106b3c,public X-Google-Thread: f6611,1aaba471388bd669 X-Google-Attributes: gidf6611,public X-Google-Thread: 104de1,1aaba471388bd669 X-Google-Attributes: gid104de1,public X-Google-Thread: ff4b7,1aaba471388bd669 X-Google-Attributes: gidff4b7,public From: Brent R Brian <BrentRBrian@prodigy.net> Subject: Re: search function Date: 1999/09/28 Message-ID: <37F0E2F2.D4D03BCF@prodigy.net> X-Deja-AN: 530323752 Content-Transfer-Encoding: 7bit References: <7so02k$nau$1@bunyip.cc.uq.edu.au> <37EF8D80.2FC8B2EC@prodigy.net> <37F00D1E.6127A629@student.uq.edu.au> <37F0260D.307A45AA@student.uq.edu.au> Content-Type: text/plain; charset=us-ascii X-Trace: ralph.vnet.net 938533450 166.82.242.62 (Tue, 28 Sep 1999 11:44:10 EDT) Organization: Vnet Internet Access MIME-Version: 1.0 Reply-To: BrentRBrian@prodigy.net NNTP-Posting-Date: Tue, 28 Sep 1999 11:44:10 EDT Newsgroups: alt.comp.databases.xbase.clipper,bit.databases.mssql-l,comp.databases,comp.databases.adabas,comp.databases.btrieve,comp.databases.filemaker,comp.databases.ms-access,comp.databases.ms-sqlserver,comp.lang.basic.visual.database,microsoft.public.vb.d