searching using text box and query

hi,

i have a films table and form. i have a txt field in teh form called
txtSearch , and i;ve created a query with all the film table fields in it.

how can i get the query to load up, wth the required film infromation in
it??

i've a query called qryFilmQuery

and on the actors criterea bit, i've got;

[Forms]![frmFilm]![txtSearch]

so that indicates, wateva is in the txtSearch field in the frmFilm. right.

on the film form i've got;

Private Sub Command55_Click()

DoCmd.OpenQuery "qryFilmQuery"

End Sub

but i need a line in there, which gives the search value? e.g. if i put in
jet li, it shuold load the query, and display every film with jet li in it.

TIA

dev

re: searching using text box and query

On Fri, 24 Feb 2006 17:42:12 GMT, "DP" <DP@hotmail.com> wrote:

What if that query qryFilmQuery would "look back" at your form where
you entered the actor (presumably a dropdown with ActorID,ActorName):
select * from Films where
SillyActorID=Forms!MyCriteriaForm!MyActorsDropdown

-Tom.


[color=blue]
>hi,
>
> i have a films table and form. i have a txt field in teh form called
>txtSearch , and i;ve created a query with all the film table fields in it.
>
>how can i get the query to load up, wth the required film infromation in
>it??
>
>i've a query called qryFilmQuery
>
>and on the actors criterea bit, i've got;
>
>[Forms]![frmFilm]![txtSearch]
>
>so that indicates, wateva is in the txtSearch field in the frmFilm. right.
>
>on the film form i've got;
>
>Private Sub Command55_Click()
>
> DoCmd.OpenQuery "qryFilmQuery"
>
>End Sub
>
>but i need a line in there, which gives the search value? e.g. if i put in
>jet li, it shuold load the query, and display every film with jet li in it.
>
>TIA
>
>dev
>[/color]

re: searching using text box and query

i thought of doing that first, but realised that after say 100 records, the
drop down list would become too big. thats y i think it would be easier if
it was assigned to a text box.

wat do u think?

dev

"Tom van Stiphout" <no.spam.tom7744@cox.net> wrote in message
news:lupvv15uiivriqggtjn7mmutlpq2a182bn@4ax.com...[color=blue]
> On Fri, 24 Feb 2006 17:42:12 GMT, "DP" <DP@hotmail.com> wrote:
>
> What if that query qryFilmQuery would "look back" at your form where
> you entered the actor (presumably a dropdown with ActorID,ActorName):
> select * from Films where
> SillyActorID=Forms!MyCriteriaForm!MyActorsDropdown
>
> -Tom.
>
>
>[color=green]
> >hi,
> >
> > i have a films table and form. i have a txt field in teh form called
> >txtSearch , and i;ve created a query with all the film table fields in[/color][/color]
it.[color=blue][color=green]
> >
> >how can i get the query to load up, wth the required film infromation in
> >it??
> >
> >i've a query called qryFilmQuery
> >
> >and on the actors criterea bit, i've got;
> >
> >[Forms]![frmFilm]![txtSearch]
> >
> >so that indicates, wateva is in the txtSearch field in the frmFilm.[/color][/color]
right.[color=blue][color=green]
> >
> >on the film form i've got;
> >
> >Private Sub Command55_Click()
> >
> > DoCmd.OpenQuery "qryFilmQuery"
> >
> >End Sub
> >
> >but i need a line in there, which gives the search value? e.g. if i put[/color][/color]
in[color=blue][color=green]
> >jet li, it shuold load the query, and display every film with jet li in[/color][/color]
it.[color=blue][color=green]
> >
> >TIA
> >
> >dev
> >[/color]
>[/color]

re: searching using text box and query

I would use after update and not on click
Is it not working with what you have?
What happens when you try to execute
Jerry

On Fri, 24 Feb 2006 17:42:12 GMT, "DP" <DP@hotmail.com> wrote:
[color=blue]
>hi,
>
> i have a films table and form. i have a txt field in teh form called
>txtSearch , and i;ve created a query with all the film table fields in it.
>
>how can i get the query to load up, wth the required film infromation in
>it??
>
>i've a query called qryFilmQuery
>
>and on the actors criterea bit, i've got;
>
>[Forms]![frmFilm]![txtSearch]
>
>so that indicates, wateva is in the txtSearch field in the frmFilm. right.
>
>on the film form i've got;
>
>Private Sub Command55_Click()
>
> DoCmd.OpenQuery "qryFilmQuery"
>
>End Sub
>
>but i need a line in there, which gives the search value? e.g. if i put in
>jet li, it shuold load the query, and display every film with jet li in it.
>
>TIA
>
>dev
>[/color]

re: searching using text box and query

I've just sent you a zip file (via email) with a sample database that
I might use..is this what you're after?
Jerry

re: searching using text box and query

i've done it. sorry for troubling you.

it works perfectly.
i wanted to know if i can use that same query to carry out different
searches? e.g could i create a search for directors, using the same query??

or would i have to create another query, for each different search?

thanx
d
ev


"Jerome Ranch" <ranchjp@mchsi.com> wrote in message
news:jus0029sen5d3vudqb8n15ersq406o2g6d@4ax.com...[color=blue]
> I've just sent you a zip file (via email) with a sample database that
> I might use..is this what you're after?
> Jerry[/color]

re: searching using text box and query

yes

if you're using text boxes, I usually have a cmd button clear all the
text boxes

and in the query I would use in the criteria
(this will wildcard for actor, and director)

like *&[forms]![frmMovieSelect]![txtActor]&*

and in the director criteria use

*&[forms]![frmMovieSelect]![txtDirector]&*


you can use both at the same time to, and wildcard in the text box




On Sat, 25 Feb 2006 15:18:07 GMT, "DP" <DP@hotmail.com> wrote:
[color=blue]
>i've done it. sorry for troubling you.
>
>it works perfectly.
>i wanted to know if i can use that same query to carry out different
>searches? e.g could i create a search for directors, using the same query??
>
>or would i have to create another query, for each different search?
>
>thanx
>d
>ev
>
>
>"Jerome Ranch" <ranchjp@mchsi.com> wrote in message
>news:jus0029sen5d3vudqb8n15ersq406o2g6d@4ax.com.. .[color=green]
>> I've just sent you a zip file (via email) with a sample database that
>> I might use..is this what you're after?
>> Jerry[/color]
>[/color]

re: searching using text box and query

hi,

so this is wat i've got;

SELECT tblFilm.FilmID, tblFilm.FilmTitle, tblFilm.Format,
tblFilm.ActorsActresses, tblFilm.Director, tblFilm.Genre, tblFilm.Link,
tblFilm.RentPriceCode, tblFilm.Rating, tblFilm.Certificate, tblFilm.CopyNo,
tblFilm.DatePurchased, tblFilm.Active, tblFilm.Available, tblFilm.Condition,
tblFilm.DateReleased
FROM tblFilm
WHERE (((tblFilm.ActorsActresses)="*" & forms!frmFilm2!txtActorSearch & "*")
And ((tblFilm.Director)="*" & forms!frmFilm2!txtDirectorSearch & "*"));

thats the sql for the query.(above)

below is the code i have for the form; (Note it may look confusing, because
i created 2 queries to do searches, but now i;m trying your way);

Private Sub cmdActorSearch_Click()
DoCmd.OpenQuery "qryFilmQuery1"
txtActorSearch = ""
End Sub


Private Sub cmdDirectorSearch_Click()
DoCmd.OpenQuery "qryFilmQuery1"
txtDirectorSearch = ""
End Sub

i;ve tried wat u gave me, and i cant get it to work. i tihnk it might be teh
sql statement? (ive never seen the '*' and '&' used before? so i dont know
how to use them. Its probably a syntax error.

thanx
dev



"Jerome Ranch" <ranchjp@mchsi.com> wrote in message
news:u8t002hogfrsppfambhrl8cof79srbuq3c@4ax.com...[color=blue]
> yes
>
> if you're using text boxes, I usually have a cmd button clear all the
> text boxes
>
> and in the query I would use in the criteria
> (this will wildcard for actor, and director)
>
> like *&[forms]![frmMovieSelect]![txtActor]&*
>
> and in the director criteria use
>
> *&[forms]![frmMovieSelect]![txtDirector]&*
>
>
> you can use both at the same time to, and wildcard in the text box
>
>
>
>
> On Sat, 25 Feb 2006 15:18:07 GMT, "DP" <DP@hotmail.com> wrote:
>[color=green]
> >i've done it. sorry for troubling you.
> >
> >it works perfectly.
> >i wanted to know if i can use that same query to carry out different
> >searches? e.g could i create a search for directors, using the same[/color][/color]
query??[color=blue][color=green]
> >
> >or would i have to create another query, for each different search?
> >
> >thanx
> >d
> >ev
> >
> >
> >"Jerome Ranch" <ranchjp@mchsi.com> wrote in message
> >news:jus0029sen5d3vudqb8n15ersq406o2g6d@4ax.com.. .[color=darkred]
> >> I've just sent you a zip file (via email) with a sample database that
> >> I might use..is this what you're after?
> >> Jerry[/color]
> >[/color][/color]

re: searching using text box and query

>i;ve tried wat u gave me, and i cant get it to work. i tihnk it might be teh[color=blue]
>sql statement? (ive never seen the '*' and '&' used before? so i dont know
>how to use them. Its probably a syntax error.[/color]

in the criteria of a select qry, I have this in one of my db that
works fine

Like "*" & [forms].[frmHELLO].[selWILDCARDELEMENT] & "*"


[selWILDCARDELEMENT] is a txt box in a form where the user inputs any
string to find the string in a field; they double click a button that
has a docmd.requery


But it looks like that's what you have in your sql below..you should
need only one query since you're wildcarding the search fields...do
you clear them after each qry?



On Sat, 25 Feb 2006 15:34:37 GMT, "DP" <DP@hotmail.com> wrote:
[color=blue]
>hi,
>
> so this is wat i've got;
>
>SELECT tblFilm.FilmID, tblFilm.FilmTitle, tblFilm.Format,
>tblFilm.ActorsActresses, tblFilm.Director, tblFilm.Genre, tblFilm.Link,
>tblFilm.RentPriceCode, tblFilm.Rating, tblFilm.Certificate, tblFilm.CopyNo,
>tblFilm.DatePurchased, tblFilm.Active, tblFilm.Available, tblFilm.Condition,
>tblFilm.DateReleased
>FROM tblFilm
>WHERE (((tblFilm.ActorsActresses)="*" & forms!frmFilm2!txtActorSearch & "*")
>And ((tblFilm.Director)="*" & forms!frmFilm2!txtDirectorSearch & "*"));
>
>thats the sql for the query.(above)
>
>below is the code i have for the form; (Note it may look confusing, because
>i created 2 queries to do searches, but now i;m trying your way);
>
>Private Sub cmdActorSearch_Click()
> DoCmd.OpenQuery "qryFilmQuery1"
> txtActorSearch = ""
>End Sub
>
>
>Private Sub cmdDirectorSearch_Click()
> DoCmd.OpenQuery "qryFilmQuery1"
> txtDirectorSearch = ""
>End Sub
>
>i;ve tried wat u gave me, and i cant get it to work. i tihnk it might be teh
>sql statement? (ive never seen the '*' and '&' used before? so i dont know
>how to use them. Its probably a syntax error.
>
>thanx
>dev
>
>
>
>"Jerome Ranch" <ranchjp@mchsi.com> wrote in message
>news:u8t002hogfrsppfambhrl8cof79srbuq3c@4ax.com.. .[color=green]
>> yes
>>
>> if you're using text boxes, I usually have a cmd button clear all the
>> text boxes
>>
>> and in the query I would use in the criteria
>> (this will wildcard for actor, and director)
>>
>> like *&[forms]![frmMovieSelect]![txtActor]&*
>>
>> and in the director criteria use
>>
>> *&[forms]![frmMovieSelect]![txtDirector]&*
>>
>>
>> you can use both at the same time to, and wildcard in the text box
>>
>>
>>
>>
>> On Sat, 25 Feb 2006 15:18:07 GMT, "DP" <DP@hotmail.com> wrote:
>>[color=darkred]
>> >i've done it. sorry for troubling you.
>> >
>> >it works perfectly.
>> >i wanted to know if i can use that same query to carry out different
>> >searches? e.g could i create a search for directors, using the same[/color][/color]
>query??[color=green][color=darkred]
>> >
>> >or would i have to create another query, for each different search?
>> >
>> >thanx
>> >d
>> >ev
>> >
>> >
>> >"Jerome Ranch" <ranchjp@mchsi.com> wrote in message
>> >news:jus0029sen5d3vudqb8n15ersq406o2g6d@4ax.com.. .
>> >> I've just sent you a zip file (via email) with a sample database that
>> >> I might use..is this what you're after?
>> >> Jerry
>> >[/color][/color]
>[/color]

re: searching using text box and query

i done it now.

i just put an 'OR' in between the statements.

is there a way to clear all the txt boxes in a form?
i want to clear all of them, and not just one of them. (and i dont want to
type in clear for all the fields.)

thanx

dev

"DP" <DP@hotmail.com> wrote in message
news:hO_Lf.60062$mf2.40292@newsfe6-win.ntli.net...[color=blue]
> hi,
>
> so this is wat i've got;
>
> SELECT tblFilm.FilmID, tblFilm.FilmTitle, tblFilm.Format,
> tblFilm.ActorsActresses, tblFilm.Director, tblFilm.Genre, tblFilm.Link,
> tblFilm.RentPriceCode, tblFilm.Rating, tblFilm.Certificate,[/color]
tblFilm.CopyNo,[color=blue]
> tblFilm.DatePurchased, tblFilm.Active, tblFilm.Available,[/color]
tblFilm.Condition,[color=blue]
> tblFilm.DateReleased
> FROM tblFilm
> WHERE (((tblFilm.ActorsActresses)="*" & forms!frmFilm2!txtActorSearch &[/color]
"*")[color=blue]
> And ((tblFilm.Director)="*" & forms!frmFilm2!txtDirectorSearch & "*"));
>
> thats the sql for the query.(above)
>
> below is the code i have for the form; (Note it may look confusing,[/color]
because[color=blue]
> i created 2 queries to do searches, but now i;m trying your way);
>
> Private Sub cmdActorSearch_Click()
> DoCmd.OpenQuery "qryFilmQuery1"
> txtActorSearch = ""
> End Sub
>
>
> Private Sub cmdDirectorSearch_Click()
> DoCmd.OpenQuery "qryFilmQuery1"
> txtDirectorSearch = ""
> End Sub
>
> i;ve tried wat u gave me, and i cant get it to work. i tihnk it might be[/color]
teh[color=blue]
> sql statement? (ive never seen the '*' and '&' used before? so i dont know
> how to use them. Its probably a syntax error.
>
> thanx
> dev
>
>
>
> "Jerome Ranch" <ranchjp@mchsi.com> wrote in message
> news:u8t002hogfrsppfambhrl8cof79srbuq3c@4ax.com...[color=green]
> > yes
> >
> > if you're using text boxes, I usually have a cmd button clear all the
> > text boxes
> >
> > and in the query I would use in the criteria
> > (this will wildcard for actor, and director)
> >
> > like *&[forms]![frmMovieSelect]![txtActor]&*
> >
> > and in the director criteria use
> >
> > *&[forms]![frmMovieSelect]![txtDirector]&*
> >
> >
> > you can use both at the same time to, and wildcard in the text box
> >
> >
> >
> >
> > On Sat, 25 Feb 2006 15:18:07 GMT, "DP" <DP@hotmail.com> wrote:
> >[color=darkred]
> > >i've done it. sorry for troubling you.
> > >
> > >it works perfectly.
> > >i wanted to know if i can use that same query to carry out different
> > >searches? e.g could i create a search for directors, using the same[/color][/color]
> query??[color=green][color=darkred]
> > >
> > >or would i have to create another query, for each different search?
> > >
> > >thanx
> > >d
> > >ev
> > >
> > >
> > >"Jerome Ranch" <ranchjp@mchsi.com> wrote in message
> > >news:jus0029sen5d3vudqb8n15ersq406o2g6d@4ax.com.. .
> > >> I've just sent you a zip file (via email) with a sample database that
> > >> I might use..is this what you're after?
> > >> Jerry
> > >[/color][/color]
>
>[/color]

re: searching using text box and query

I use a command button on the form
use an On Double Click Event
Here's an example from a db of mine

a double click clears the two cbo (in your case the txt boxes),
reloads the data source with the requery, and then clears the form
(i.e. runs the query with nothing selected)

Private Sub cmdClear_DblClick(Cancel As Integer)
Me.cboCREATORSELECT = ""
Me.cboEXPTSELECT = ""
Me.cboCREATORSELECT.Requery
Me.cboEXPTSELECT.Requery
Me.frmEXPTINFO.Requery
End Sub


you won't need but the first two where you set the txt boxes = ""

jerry


On Sat, 25 Feb 2006 16:57:14 GMT, "DP" <DP@hotmail.com> wrote:
[color=blue]
>i done it now.
>
> i just put an 'OR' in between the statements.
>
>is there a way to clear all the txt boxes in a form?
>i want to clear all of them, and not just one of them. (and i dont want to
>type in clear for all the fields.)
>
>thanx
>
>dev
>
>"DP" <DP@hotmail.com> wrote in message
>news:hO_Lf.60062$mf2.40292@newsfe6-win.ntli.net...[color=green]
>> hi,
>>
>> so this is wat i've got;
>>
>> SELECT tblFilm.FilmID, tblFilm.FilmTitle, tblFilm.Format,
>> tblFilm.ActorsActresses, tblFilm.Director, tblFilm.Genre, tblFilm.Link,
>> tblFilm.RentPriceCode, tblFilm.Rating, tblFilm.Certificate,[/color]
>tblFilm.CopyNo,[color=green]
>> tblFilm.DatePurchased, tblFilm.Active, tblFilm.Available,[/color]
>tblFilm.Condition,[color=green]
>> tblFilm.DateReleased
>> FROM tblFilm
>> WHERE (((tblFilm.ActorsActresses)="*" & forms!frmFilm2!txtActorSearch &[/color]
>"*")[color=green]
>> And ((tblFilm.Director)="*" & forms!frmFilm2!txtDirectorSearch & "*"));
>>
>> thats the sql for the query.(above)
>>
>> below is the code i have for the form; (Note it may look confusing,[/color]
>because[color=green]
>> i created 2 queries to do searches, but now i;m trying your way);
>>
>> Private Sub cmdActorSearch_Click()
>> DoCmd.OpenQuery "qryFilmQuery1"
>> txtActorSearch = ""
>> End Sub
>>
>>
>> Private Sub cmdDirectorSearch_Click()
>> DoCmd.OpenQuery "qryFilmQuery1"
>> txtDirectorSearch = ""
>> End Sub
>>
>> i;ve tried wat u gave me, and i cant get it to work. i tihnk it might be[/color]
>teh[color=green]
>> sql statement? (ive never seen the '*' and '&' used before? so i dont know
>> how to use them. Its probably a syntax error.
>>
>> thanx
>> dev
>>
>>
>>
>> "Jerome Ranch" <ranchjp@mchsi.com> wrote in message
>> news:u8t002hogfrsppfambhrl8cof79srbuq3c@4ax.com...[color=darkred]
>> > yes
>> >
>> > if you're using text boxes, I usually have a cmd button clear all the
>> > text boxes
>> >
>> > and in the query I would use in the criteria
>> > (this will wildcard for actor, and director)
>> >
>> > like *&[forms]![frmMovieSelect]![txtActor]&*
>> >
>> > and in the director criteria use
>> >
>> > *&[forms]![frmMovieSelect]![txtDirector]&*
>> >
>> >
>> > you can use both at the same time to, and wildcard in the text box
>> >
>> >
>> >
>> >
>> > On Sat, 25 Feb 2006 15:18:07 GMT, "DP" <DP@hotmail.com> wrote:
>> >
>> > >i've done it. sorry for troubling you.
>> > >
>> > >it works perfectly.
>> > >i wanted to know if i can use that same query to carry out different
>> > >searches? e.g could i create a search for directors, using the same[/color]
>> query??[color=darkred]
>> > >
>> > >or would i have to create another query, for each different search?
>> > >
>> > >thanx
>> > >d
>> > >ev
>> > >
>> > >
>> > >"Jerome Ranch" <ranchjp@mchsi.com> wrote in message
>> > >news:jus0029sen5d3vudqb8n15ersq406o2g6d@4ax.com.. .
>> > >> I've just sent you a zip file (via email) with a sample database that
>> > >> I might use..is this what you're after?
>> > >> Jerry
>> > >[/color]
>>
>>[/color]
>[/color]

re: searching using text box and query

yep, i've already done that. thanx for all yor help. i got them all working.

thanx again

dev

"Jerome Ranch" <ranchjp@mchsi.com> wrote in message
news:nu5102ddp7s9a853hms4usg6jjcuia1c8g@4ax.com...[color=blue]
> I use a command button on the form
> use an On Double Click Event
> Here's an example from a db of mine
>
> a double click clears the two cbo (in your case the txt boxes),
> reloads the data source with the requery, and then clears the form
> (i.e. runs the query with nothing selected)
>
> Private Sub cmdClear_DblClick(Cancel As Integer)
> Me.cboCREATORSELECT = ""
> Me.cboEXPTSELECT = ""
> Me.cboCREATORSELECT.Requery
> Me.cboEXPTSELECT.Requery
> Me.frmEXPTINFO.Requery
> End Sub
>
>
> you won't need but the first two where you set the txt boxes = ""
>
> jerry
>
>
> On Sat, 25 Feb 2006 16:57:14 GMT, "DP" <DP@hotmail.com> wrote:
>[color=green]
> >i done it now.
> >
> > i just put an 'OR' in between the statements.
> >
> >is there a way to clear all the txt boxes in a form?
> >i want to clear all of them, and not just one of them. (and i dont want[/color][/color]
to[color=blue][color=green]
> >type in clear for all the fields.)
> >
> >thanx
> >
> >dev
> >
> >"DP" <DP@hotmail.com> wrote in message
> >news:hO_Lf.60062$mf2.40292@newsfe6-win.ntli.net...[color=darkred]
> >> hi,
> >>
> >> so this is wat i've got;
> >>
> >> SELECT tblFilm.FilmID, tblFilm.FilmTitle, tblFilm.Format,
> >> tblFilm.ActorsActresses, tblFilm.Director, tblFilm.Genre, tblFilm.Link,
> >> tblFilm.RentPriceCode, tblFilm.Rating, tblFilm.Certificate,[/color]
> >tblFilm.CopyNo,[color=darkred]
> >> tblFilm.DatePurchased, tblFilm.Active, tblFilm.Available,[/color]
> >tblFilm.Condition,[color=darkred]
> >> tblFilm.DateReleased
> >> FROM tblFilm
> >> WHERE (((tblFilm.ActorsActresses)="*" & forms!frmFilm2!txtActorSearch &[/color]
> >"*")[color=darkred]
> >> And ((tblFilm.Director)="*" & forms!frmFilm2!txtDirectorSearch & "*"));
> >>
> >> thats the sql for the query.(above)
> >>
> >> below is the code i have for the form; (Note it may look confusing,[/color]
> >because[color=darkred]
> >> i created 2 queries to do searches, but now i;m trying your way);
> >>
> >> Private Sub cmdActorSearch_Click()
> >> DoCmd.OpenQuery "qryFilmQuery1"
> >> txtActorSearch = ""
> >> End Sub
> >>
> >>
> >> Private Sub cmdDirectorSearch_Click()
> >> DoCmd.OpenQuery "qryFilmQuery1"
> >> txtDirectorSearch = ""
> >> End Sub
> >>
> >> i;ve tried wat u gave me, and i cant get it to work. i tihnk it might[/color][/color][/color]
be[color=blue][color=green]
> >teh[color=darkred]
> >> sql statement? (ive never seen the '*' and '&' used before? so i dont[/color][/color][/color]
know[color=blue][color=green][color=darkred]
> >> how to use them. Its probably a syntax error.
> >>
> >> thanx
> >> dev
> >>
> >>
> >>
> >> "Jerome Ranch" <ranchjp@mchsi.com> wrote in message
> >> news:u8t002hogfrsppfambhrl8cof79srbuq3c@4ax.com...
> >> > yes
> >> >
> >> > if you're using text boxes, I usually have a cmd button clear all the
> >> > text boxes
> >> >
> >> > and in the query I would use in the criteria
> >> > (this will wildcard for actor, and director)
> >> >
> >> > like *&[forms]![frmMovieSelect]![txtActor]&*
> >> >
> >> > and in the director criteria use
> >> >
> >> > *&[forms]![frmMovieSelect]![txtDirector]&*
> >> >
> >> >
> >> > you can use both at the same time to, and wildcard in the text box
> >> >
> >> >
> >> >
> >> >
> >> > On Sat, 25 Feb 2006 15:18:07 GMT, "DP" <DP@hotmail.com> wrote:
> >> >
> >> > >i've done it. sorry for troubling you.
> >> > >
> >> > >it works perfectly.
> >> > >i wanted to know if i can use that same query to carry out different
> >> > >searches? e.g could i create a search for directors, using the same
> >> query??
> >> > >
> >> > >or would i have to create another query, for each different search?
> >> > >
> >> > >thanx
> >> > >d
> >> > >ev
> >> > >
> >> > >
> >> > >"Jerome Ranch" <ranchjp@mchsi.com> wrote in message
> >> > >news:jus0029sen5d3vudqb8n15ersq406o2g6d@4ax.com.. .
> >> > >> I've just sent you a zip file (via email) with a sample database[/color][/color][/color]
that[color=blue][color=green][color=darkred]
> >> > >> I might use..is this what you're after?
> >> > >> Jerry
> >> > >
> >>
> >>[/color]
> >[/color][/color]