🚀 go-pugleaf

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

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

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

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

Standard wildcards, I beleive, so it would be

    select * where my_column like "*<text>*"

I know this, because I often have to do a "manual" query in design view -
and in the criteria, one types

    Like "*dave*"

to search for dave.  I am not sure how you would parse the users' entry into
the SQL statement, though - would you
use this?

    select * where my_column like "*[forms]![Form Name]![User Text]*"

Any thoughts?

Tom Kelsall

Forgive me, the "%" is for ADABAS databases .... 

B


LeemingIT wrote:
> 
> Standard wildcards, I beleive, so it would be
> 
>     select * where my_column like "*<text>*"
> 
> I know this, because I often have to do a "manual" query in design view -
> and in the criteria, one types
> 
>     Like "*dave*"
> 
> to search for dave.  I am not sure how you would parse the users' entry into
> the SQL statement, though - would you
> use this?
> 
>     select * where my_column like "*[forms]![Form Name]![User Text]*"
> 
> Any thoughts?
> 
> Tom Kelsall

LeemingIT (ITManager@LeemingIT.demon.co.uk) wrote:
: Standard wildcards, I beleive, so it would be

:     select * where my_column like "*<text>*"

Isn't the standard character the % (percent)? Like in:
... like "%adrian%"


-- 
         *** Learn Esperanto - the International Language! ***
One language for all           |      Unu por chiuj,
the second for everyone!       |     la dua por chiu!

I got a solution.
I used the wildcard, but the tricky part was to make it read in the
value from the form.
This is what ive got:

SELECT * FROM <Tables>
WHERE SEARCHWORD Like "*"&([Forms]![formname]![textkeyword])&"*"))

thanks everyone for their help

Adrian Boldan wrote:

> LeemingIT (ITManager@LeemingIT.demon.co.uk) wrote:
> : Standard wildcards, I beleive, so it would be
>
> :     select * where my_column like "*<text>*"
>
> Isn't the standard character the % (percent)? Like in:
> ... like "%adrian%"
>
> --
>          *** Learn Esperanto - the International Language! ***
> One language for all           |      Unu por chiuj,
> the second for everyone!       |     la dua por chiu!

>Isn't the standard character the % (percent)? Like in:
>... like "%adrian%"


Not in Access, or Windows NT, or Windows 95, or DOS.  In Windows NT, the "%"
means "The next string of characters is a Windows NT word such as "USERNAME"
which you should replace with a value".  The second "%" replaces this.  In
Access " * " means "Any number of any character".

Tom