Request - What's the easiest way to make a search field on a form?

[Captain Wonky]

As the subject says... I'm a database novice even though I've been
trying to learn Access for years. I've 'almost finished' several
databases but always get stumped on something - this time it's search
fields (well, ONE of the things.. ).
I'm creating a simple database to track various software licenses on
various computers and I'd like to have a 'type and find' search field
in a form. I can't seem to find out how to do this.
All info (and some pointers on good form tutorials) would be
gratefully accepted. Thank- you.

Some days you're the windscreen,
and some days you're the bug.
............... ............... ............... ............... ..

[Edward]

Re: Request - What's the easiest way to make a search field on a form?

Captain Wonky <FireLasers@The B.org> wrote in message news:<4tuc005dc najdflatmlo75ld 08rnudfroh@4ax. com>...[color=blue]
> As the subject says... I'm a database novice even though I've been
> trying to learn Access for years. I've 'almost finished' several
> databases but always get stumped on something - this time it's search
> fields (well, ONE of the things.. ).
> I'm creating a simple database to track various software licenses on
> various computers and I'd like to have a 'type and find' search field
> in a form. I can't seem to find out how to do this.
> All info (and some pointers on good form tutorials) would be
> gratefully accepted. Thank- you.
>
> Some days you're the windscreen,
> and some days you're the bug.
> ............... ............... ............... ............... .[/color]

Although I've only rarely used it myself, Access provides you with a
wizard to do just this. Add a command button to your form and the
Command Button wizard will allow you to create a button. Select
"Record Navigation" in the Categories list, and "Find Record" in the
Actions list. Then follow the steps to the end. It will allow you to
search in most of the fields in the recordset to which your form is
attached.

HTH

Edward
--
The reading group's reading group:

http://www.bookgroup.org.uk

[Bruce]

Re: Request - What's the easiest way to make a search field on a form?

Captain Wonky <FireLasers@The B.org> wrote in message news:<4tuc005dc najdflatmlo75ld 08rnudfroh@4ax. com>...[color=blue]
> As the subject says... I'm a database novice even though I've been
> trying to learn Access for years. I've 'almost finished' several
> databases but always get stumped on something - this time it's search
> fields (well, ONE of the things.. ).
> I'm creating a simple database to track various software licenses on
> various computers and I'd like to have a 'type and find' search field
> in a form. I can't seem to find out how to do this.
> All info (and some pointers on good form tutorials) would be
> gratefully accepted. Thank- you.[/color]

There's a 'find' already built into Access...click on the field on
your form that you want to search with and press ctrl F. This is the
easiest way.

Check out the northwind.mdb sample database and online help that comes
with Access for more good Access forms information.

Bruce

[Captain Wonky]

Re: Request - What's the easiest way to make a search field on a form?

On 15 Jan 2004 06:56:39 -0800, teddysnips@hotm ail.com (Edward) wrote:
[color=blue]
>Captain Wonky <FireLasers@The B.org> wrote in message news:<4tuc005dc najdflatmlo75ld 08rnudfroh@4ax. com>...[color=green]
>> As the subject says... I'm a database novice even though I've been
>> trying to learn Access for years. I've 'almost finished' several
>> databases but always get stumped on something - this time it's search
>> fields (well, ONE of the things.. ).
>> I'm creating a simple database to track various software licenses on
>> various computers and I'd like to have a 'type and find' search field
>> in a form. I can't seem to find out how to do this.
>> All info (and some pointers on good form tutorials) would be
>> gratefully accepted. Thank- you.
>>
>> Some days you're the windscreen,
>> and some days you're the bug.
>> ............... ............... ............... ............... .[/color]
>
>Although I've only rarely used it myself, Access provides you with a
>wizard to do just this. Add a command button to your form and the
>Command Button wizard will allow you to create a button. Select
>"Record Navigation" in the Categories list, and "Find Record" in the
>Actions list. Then follow the steps to the end. It will allow you to
>search in most of the fields in the recordset to which your form is
>attached.
>[/color]

Thank-you for the answer, but this isn't what I want. I'd like to
simply have a combo box in a table that you can either a) type in the
item you're searching for (to bring up associated record fields) and
b) click the arrow and see all items in ascending order. Any ideas?
[color=blue]
>HTH
>
>Edward[/color]

Some days you're the windscreen,
and some days you're the bug.
............... ............... ............... ............... ..

[Pieter Linden]

Re: Request - What's the easiest way to make a search field on a form?

(Seems I'm *always* the bug...)

You could create an unbound field/combobox on a form and then use that
as a filter. Or just check out this article. It has a file you can
download and use...

http://www.mvps.org/access/forms/frm0045.htm