Kind of search function

  • Thread starter Thread starter Comancheace
  • Start date Start date
C

Comancheace

I would like to know if it´s possible to make a text box
where you put the
username you want to search and then it gives you all the
data related to that username? If it is how can i do it?

Thanks
 
Sure, Just reference that field in your query under the UserName column so
that it limits the query results by the entry in the field.

Something like...

=Forms![MySearchFormName]![MySearchFieldName]





Rick B




I would like to know if it´s possible to make a text box
where you put the
username you want to search and then it gives you all the
data related to that username? If it is how can i do it?

Thanks
 
Try adding a combo box to the form, using the wizard, and choose "find a
record..."

I would like to know if it´s possible to make a text box
where you put the
username you want to search and then it gives you all the
data related to that username? If it is how can i do it?

Thanks
 
You mean, i put that info in the Criteria, creating like
this a Parameter Query. But the problem is that parameter
requires you to enter the exact name of the username.
Isn´t there any other criteria that can show me for
example all the John´s if i only type John? Do you get it?

Thanks
 
I was more like thinking of making a parameter query
instead. Thanks. The Criteria im using is something like:=
[Enter your username]. This means that you have to type
the exactly username or it will appear nothing. For
example if the name John Mcnroe is in the database and if
you type John it will appear no results. You have to type
John Mcnroe. And i wanted you to type John and appeared
all the John´s in the database. It´s some function i have
to put in the criteria similar to = but i don´t know wich
is. Can you please help me on this?
 
Back
Top