Search Function in Database?

G

Guest

Guys,
I have Access 2003.

I created a database using the template within Access - 'Orderentry'

I have now 671 customer records in the database. (26 Meg)

I now want to add a search function so I can search for:

1. A particular customer it will bring all invoices up

2. Search for postal code and it will bring up all records matching for that
area.

3. Search for suburb/ town - again brings them all up.

Any ideas on a simple way to do it?

I have no idea with the programming of access.

Is there an addin?

Help appreciated.

Darren
 
M

MacDermott

What you are asking for is usually called "filtering" rather than
"searching". (Searching usually returns the first match - then may move to
the next match, etc. - the point is it returns one record at a time.)

One of the easiest ways to filter is to put your cursor in the field you
want to filter on, and right click.
You can choose to show all records which match the one you've clicked, all
except that value, or all which match a value you type in.

Another way to filter is using the FilterByForm button on your toolbar.
(Hover your cursor over the toolbar buttons until you find it.)

You can also look up Filter in the Access Help file, or your preferred
instrument of learning.

HTH
 
P

PC Datasheet

First of all, when your database is open, click on Tools - Database
Utilities - Compact and Repair. Then check the size of your database file.

For Search, do a Google search at www.groups.google.com on "Search Form" and
you will find more than enough information on how to do the search you want.
 
G

Guest

Thanks guys,

I have tried playing around with filtering. yes can work it ok.

Be nice to have a filtering button on the main switchboard then filter
anything from that rather than open up the customer form.

Searching google now for "Search Form"

Ta guys


DArren
 
M

MacDermott

That can be done, but it will require some VBA coding.
It's not built in.

- Turtle
 
Top