Using Search in a Data BAse

[elfredo]

Hi There

I am a complete newbie at this access thing. Here what i want help on.

I have 1 table containing locations of Radio masts. In that table is the id number & name, town location, post code etc.

What i want is instead of scrolling down the whole table to look for a particular site. I want to create asearch facility that i just need to type in certain information e.g. "Town name" and het presto up comes my information. I want to be able to define my search appropiately.

Can access do this. If so, how do i do it and can you make it in layman terms please.

Elfredo.

 

[ColinEssex]

Hi

Firstly I presume that you are looking at the table through a form rather than looking at the actual table.

There are various ways to perform what you need. Can I suggest you try a search in these forums? This topic appears regularly and there are some really good anwers to your needs.

If you shouldn't have any luck, post back here and we'll knock you up a demo if you are unsure of what to do.

Col

 

[elfredo]

I have tried searching but to no avail or either that i can't understand what they are on about.

I was looking at the "switchboard". is that something to do with it?

thanks

 

[ColinEssex]

Hmmm - I think it might be an idea if you tell us what you have actually got so far in your database.

The switchboard is the opening form that has buttons on it to take you to various screens like data input / reports and the like.

Have you got any forms at all yet? or are you still developing them

You can email me your database (zipped) if it doesn't contain confidential info and I'll have a look at it if you prefer.

Col

 

[elfredo]

what is your addy?

 

[ColinEssex]

I've PM'd it to you

 

[poodlestrudels]

An answer to your question...

I saw what you want, and I have db that does just that. Make a query linked to the said table, and in the design view, write this code under the column you wish to search:

Like[*]

Replace * with what you wnat the sarch box to say when it comes up. Simply double click the query, and you are searching!

 

[HUNTERMCG]

Re: An answer to your question...

Hello,

I am a novice to Access, so I may be asking a stupid question wich has been answered many times before. But I cannot seem to find the answer I am looking for.

I added your criteria 'Like' to my query. Th search works fine. But I want to let the result shown in my form to which the table is linked. How do I do this???

And how do I edit the criteria to search for a keyword or the beginletters of, for example, a Lastname??? I believe you call this a wildcard.

Please help, I would appreciate your reply very much.

Gerdo de Jager
Netherlands

 

[poodlestrudels]

Well, I don't now about getting the results to show up in a form, but you can certainly search for keywords by putting stars around what your searching for, such as:

*water*

This makes it possible for you to search for anything linked that has the word water in their title.