**Access 2003 Search Form Creation: Complete Newbie

[Otto P.]

Hello all,

Brand new to Access 2003. I work at a library where we (me) are
creating a database for newspaper clippings that will probably total
around 4,000. The database itself is fine and looking good, but we
need to create a search form for library users to search the database.
Ideally they would be able to search on any of the text fields and see
their results either in a table or some other form.

Can someone out there please outline how one form searches another?
I've looked in manuals and books, but none seem to address this issue
very well. They are either too simple ("Use the Wizard!") or too
complex (VBA). I know there's some programming involved, something
I've never done before, so I would appreciate as straightforward a
guide as possible. Also, any suggestions for books that might address
this issue.

Thanks very much,

Otto

 

[p]

What you could do is construct a SQL query based on a text field. But
how is the newspaper clippings database constructed? Are you embedding
images or using a memo field to contain all the text within an article?

Need more info but the SQL solution is one of many

Google this or someone could help here.