Re: Creating a search function on a table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



Have you examined queries? Search Help or just go play around in the
queries.

--
Duane Hookom
MS Access MVP


"Patrick" <Patrick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2E7689E3-249B-4C41-BF28-BBB7C77C2857@xxxxxxxxxxxxxxxx
>I need help trying to create a search function for a project I am doing. I
> have two tables, one that contains customer information and another that
> contains permit information. The tables are linked by customer number, in
> a
> one to many relationship (i.e. one customer can have several permits). I
> would like to create a form that allows me to search by keyword in a
> selected
> field of the customer table. For example a search that allows me to type
> in
> a keyword and return all addresses that contain this keyword. I would
> like
> to have the results returned in table format. I am not sure how to go
> about
> this or if it is possable. I am new to Access 2000 and have been able to
> make several forms that show the data from a table. Any help would be
> appreciated.


.



Relevant Pages

  • Re: Creating a search function on a table
    ... have a combo box that list the fields of my customer table, ... If queries are the way to achieve this ... >> contains permit information. ... >> a keyword and return all addresses that contain this keyword. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Unmatched Records
    ... The way the queries choose the customer is by an open form named ... "vanderghast" wrote: ... Vanderghast, Access MVP ...
    (microsoft.public.access.queries)
  • Re: access 2003
    ... I would focus on the queries behind the combo boxes. ... the Access 97 database, I wouldn't have thought any expressions would be ... When you select a customer and a job in the two combo boxes, ...
    (microsoft.public.access.conversion)
  • Re: Calculate a percentage using 2 different query totals
    ... Duane Hookom ... It is not about using the Query Wizard because you will ... > queries from incompatible record sources. ... >> field names like [Customer ID]. ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Need Help with filtering in queries
    ... I think you are correct about filtering by date in the last queries, ... Calculations in queries slow it down. ... > I have a query called Qrpt201Summary which totals on division and order. ... > building of the division and customer combo boxes. ...
    (microsoft.public.access.formscoding)