Re: Query to search entire record, not one field?

Not sure what you are asking.

You need to build an unbound form.

This form will contain a blank UNBOUND field that the users can enter.

You can then reference each of these in your query.

--
Rick B



"consjoe" <consjoe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:52B22AC6-E51D-4BC4-9754-799D1D4A3CD2@xxxxxxxxxxxxxxxx
> Thanks for your help Rick.
> I understand the second part but am not sure about the first half.
> My Table name is "Master"
> My Search form is "Search" and is based on a different table with the same
> fields as "Master" But I think it should be based of a query of "Master"
??
> So I need a blank form that you can type in the information you want to
> search by and then click search and all records with the matching
information
> will show up.
> I tried to put in Like Forms! [Search]![State] & "&" but it put Forms! in
[]
> and when I ran the query it gave me the pop up asking for
Foms!Search!State!,
> I undertand why I got the pop up but I don't want the pop up, I want to
enter
> the information into a blank form and then search.
> Thanks again.
>
> "Rick B" wrote:
>
> > To search based on a filed in a form that may or may not contain a
value,
> > you'd use...
> >
> > Like Forms![MySearchFormName]![MySearchFieldName] & "*"
> >
> > Putting this in all the various fields in your query would pull values
that
> > match if the user had made an entry. If no entry was made for a
particular
> > field, then all the values in that field would be valid.
> >
> > --
> > Rick B
> >
> >
> >
> > "consjoe" <consjoe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:BE45E375-8EE8-48ED-BC84-EE30F1C30CB5@xxxxxxxxxxxxxxxx
> > > I have a form based on a table with 20 fields. My clients want the
> > ability
> > > to search all fields to find the record they are looking for. Is
there a
> > way
> > > for me to create a form (with all 20 fields) where they can chose
which
> > > fields to search by and those records come up?
> > > Ex. I know that state, company, and first name of a record I need. I
go
> > > into the 'Search Form' and type that information in and that record is
> > > retrieved.
> > > It is kind of like an and/or type of query but they need to be able to
> > > choose which fields to search by and leave the others blank.
> > > Thanks in advance.
> > >
> >
> >
> >


.

Relevant Pages

  • Re: Query to search entire record, not one field?
    ... Thanks for your help Rick. ... My Table name is "Master" ... and when I ran the query it gave me the pop up asking for Foms!Search!State!, ... > match if the user had made an entry. ...
    (microsoft.public.access.queries)
  • Re: Newbie: best way to send a value to many queries at once
    ... Then instead of writing [Put the year you want a report for] in the criteria ... each query in that report) each time I open the report. ... "Rick B" wrote: ... > create an unbound form and place a field on that form for the entry. ...
    (microsoft.public.access.reports)
  • Re: Invoices
    ... Sorry - you lost me. ... "Rick B" wrote: ... If the form is also used to view data, it will often be bound to a query. ... perhaps you have the "data entry" property set to ...
    (microsoft.public.access.forms)
  • Re: Form doesnt show added table information
    ... there -is- a query behind it. ... I believe Rick was probably on the right ... "KARL DEWEY" wrote: ... I checked and there are no filters. ...
    (microsoft.public.access.forms)
  • Re: Cant see "Form View" or "Layout View"
    ... Thanks Rick. ... If I have the same 6 tabs, but place all my information and controls on ... A bound form is simply a GUI to a table or query it is bound to. ... Assessments.DetailedElementsIDF) INNER JOIN (CriteriaSheet INNER JOIN ...
    (microsoft.public.access.forms)
Loading