By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,948 Members | 838 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,948 IT Pros & Developers. It's quick & easy.

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

P: n/a

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.
.................................................. ............
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Captain Wonky <Fi********@TheB.org> wrote in message news:<4t********************************@4ax.com>. ..
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.
.................................................. ...........


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
Nov 12 '05 #2

P: n/a
Captain Wonky <Fi********@TheB.org> wrote in message news:<4t********************************@4ax.com>. ..
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.


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
Nov 12 '05 #3

P: n/a
On 15 Jan 2004 06:56:39 -0800, te********@hotmail.com (Edward) wrote:
Captain Wonky <Fi********@TheB.org> wrote in message news:<4t********************************@4ax.com>. ..
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.
.................................................. ...........
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.


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?
HTH

Edward


Some days you're the windscreen,
and some days you're the bug.
.................................................. ............
Nov 12 '05 #4

P: n/a
(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
Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.