RE: Database Search Facility

Dear Mr. Schmid and Mr. Alasdair,

I encountered your posts while researching a solution to my database
problem. I have had great results from the recommended Ad-Hoc Report! I was
wondering if you had made any modifiactions to this form. Specifically, I am
curioud to know if it can be altered to search for the requested data in
multiple fields. In the bibligraphical case, if the reader knows only one
name of the author, can he type in the known name and the database searched
in both the first name and last name fields? In my case, I have an
engineering drawing that illustrates construction at 3 different pump
stations. I would like the users to be able to enter a station name, and the
database will search the fields called "StationName1", "StationName2", and
"StationName3" and report all records with the requested name in any of those
3 fields!
Any ideas? Thank you all for your help! I am particualy pleased with the
Ad-Hoc Report.mdb!
--
Keri


"rupertsland" wrote:

> Dear Alasdair.
>
> I am having the exact same problem in Access. I'm currently building a
> bibliographic system for our company. This system requires several
> user-friendly "criteria" forms. A static query is not enough.
>
> What I specifically want to do is construct a main form with a subform. The
> upper part of the main form will have criteria fields and a search button.
> When the user presses the search button, all the criteria entered are used to
> query the data. The results of the search will appear as a list of records in
> the subform. The subform will appear as a data***. I can build the main and
> subforms quite easily. Where I stumble is in setting up the criteria fields
> in the main form and linking them to a query.
>
> If anyone can help us both, we would be grateful.
>
> Dirk Schmid M.Sc.
> Data Analyst / Environmental Microbiologist
> North/South Consultants Inc.
> Winnipeg, Canada
>
> ---------------------------------
> "Alasdair" wrote:
>
> > Hello,
> >
> > I hope this is the right forum for this question, if not please suggest
> > where I should place it. I've just worked through the Step-by-step Microsoft
> > Access 2002 guide and feel comfortable creating simple queries, forms,
> > reports and tables.
> >
> > But the main activity I want to do on an existing database is to create a
> > flexible search facility into which a user can search on:-
> >
> > - partial reference numbers
> > - multiple keywords which might be found in text
> > - records which were added in certain date ranges
> >
> > I don't really know how to start doing this. I can create a query which does
> > this but I want other users to use a friendly form instead and I'm not sure
> > how to make the form allow the search methods I've mentioned.
> >
> > I'd appreciate any advice or even better a reference form and query I could
> > look at. I've programmed in VBA for Excel before but never for Access.
> >
> > Hope this all makes sense. Thanks for any suggestions.
> >
> > Cheers,
> >
> > Alasdair
.

Loading