Help on designing simple search-display form

[kostas]

Hello there i have access 2002 and i want to design a simple search form with
2 input boxes. 1st will be spare part code and the second will be
description. I want to input data into 1 or both boxes and then display some
results. In that boxew i want to be able to use the * wildcard

The table of the database will be consisted from a master key (i imagine
auto increment) the code of the spare part, the price, the description and
the image of the item). For the latest i would like to link external jpeg
files and then display them with the other results

 

[Tom van Stiphout]

On Tue, 5 Aug 2008 04:44:00 -0700, kostas

The simplest way requires no code at all: create your table > use the
Form wizard to create a form based on that table > go to the field you
want to search by and hit Ctrl+F. You can do wildcard searches (e.g.
Match any part of field) right there.
Only limitation is that you cannot search on the combination of two
fields, but for that we have Query by Form. Look it up in the Help
file.

-Tom.
Microsoft Access MVP

 

[Roger Carlson]

--
On my website (www.rogersaccesslibrary.com), is a small Access database
sample called CreateQueries.mdb which illustrates how to do this. You might
also want to look at the other "CreateQueries" samples listed there.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L