a search function?

[justin]

hello,

I'm wondering how I would go about creating a search
feature in my database.

I would like something where there is a button on the main
switchboard users could click, something titled "search
for a document," which would bring up another window (a
form possibly?) where users could then enter or select
information that they would want to search for.

I'm picturing something similar to a form, where there
would be several fields for users to enter information
into. Fields like, daterecieved, office, documentname,
document type, etc....

Then the user would enter in the information he/she knew
or wanted to search for, and click on a "search" button,
which would then take the information he/she entered into
the fields, and then output a list of the results based on
what was entered.

Is this possible? How would I do this?

Thanks for the help/advice in advance.

-justin

 

[Mike]

What you are after is called Query By Form (QBF). These instructions require
a little interpretation - http://support.microsoft.com/?kbid=209645
If you find you are still having trouble, or you are finding these
instructions difficult to follow, write back in this discussion, and i will
give you my email address. Good luck.

 

[Tom Wickerath]

Hi Mike,

I suppose KB 209645 is a good primer for people to learn the QBF technique,
without having to use VBA code. However, one would have a hard time using
this sample to accomodate checkboxes or a multi-select list box on a form,
where multiple selections were allowed. The sample that I mentioned includes
handling these situations.

Tom
________________________________________

:

What you are after is called Query By Form (QBF). These instructions require
a little interpretation - http://support.microsoft.com/?kbid=209645
If you find you are still having trouble, or you are finding these
instructions difficult to follow, write back in this discussion, and i will
give you my email address. Good luck.

 

[Mike]

G'Day Tom,
I see where you are coming from. You couldnt expect someone completely new
to the software to be able to do that straight away. I don't know much
actually when it comes to databases, and coding, but i have resorted to the
internet for any queries in design, relational database structure problems,
and, until a little while ago, QBF's. I dont disagree with purchasing a book
on the program, i have done so with many apps before. But i know i would
prefer to be told by someone how to do something rather that refer to a 500
page book, where there's usually 2 pages of relevancy to the task, and would
probably only use once. The link seemy dodgy, but its good for plain copy,
paste and edit, change a setting or 2, and with a little trial and error, i
had the search function in my database in minutes.

 

[Tom Wickerath]

Hi Mike,

But i know i would prefer to be told by someone how to do something
rather that refer to a 500 page book, where there's usually 2 pages of
relevancy to the task, and would probably only use once.

You can often times find great bargains on computer related books. For
example, I once found an unused copy of the Access Developer's Handbook
(Access 97 version), complete with the CD disk, for $ 15.99 USD at a
Half-Price Books store. There are likely bargains available on Access 2002
books right now, since this is not the current version. If you are going to
do serious work in Access, I strongly recommend investing in a personal
library.

Send me a private message, with a valid e-mail address, if you'd like to
receive a copy of the QBF sample that I mentioned.

Tom

QWaos168@XScom cast. Dnet (<--Remove all capitolized letters and spaces).

http://www.access.qbuilt.com/html/expert_contributors.html
_______________________________

:

G'Day Tom,
I see where you are coming from. You couldnt expect someone completely new
to the software to be able to do that straight away. I don't know much
actually when it comes to databases, and coding, but i have resorted to the
internet for any queries in design, relational database structure problems,
and, until a little while ago, QBF's. I dont disagree with purchasing a book
on the program, i have done so with many apps before. But i know i would
prefer to be told by someone how to do something rather that refer to a 500
page book, where there's usually 2 pages of relevancy to the task, and would
probably only use once. The link seemy dodgy, but its good for plain copy,
paste and edit, change a setting or 2, and with a little trial and error, i
had the search function in my database in minutes.

 

[MarcTA]

After I build the query and I gives me the results in a datasheet is there a
way to dbl click on the record to bring up the record in a form (that may
have more information?)

Thanks,

Marcta

 

[Tom Wickerath]

Hi Marcta,

Yes, you can do this if you display your search results in a subform. A
query does not have any event procedures available, so you cannot accomplish
this task from a query alone. The KB article that Mike referenced,
http://support.microsoft.com/?kbid=209645, is designed to open a query to
present the results.

If you send me a private e-mail message, with a valid return address, I will
send you a sample database that does what you are asking for. Whatever you
do, please do not post your real e-mail address to a newsgroup message,
unless you love to receive lots of spam.

Tom

QWaos168@XScom cast. Dnet (<--Remove all capitolized letters and spaces).

http://www.access.qbuilt.com/html/expert_contributors.html

____________________________________

:

After I build the query and I gives me the results in a datasheet is there a
way to dbl click on the record to bring up the record in a form (that may
have more information?)

Thanks,

Marcta
____________________________________

:

Hi Mike,

But i know i would prefer to be told by someone how to do something
rather that refer to a 500 page book, where there's usually 2 pages of
relevancy to the task, and would probably only use once.

You can often times find great bargains on computer related books. For
example, I once found an unused copy of the Access Developer's Handbook
(Access 97 version), complete with the CD disk, for $ 15.99 USD at a
Half-Price Books store. There are likely bargains available on Access 2002
books right now, since this is not the current version. If you are going to
do serious work in Access, I strongly recommend investing in a personal
library.

Send me a private message, with a valid e-mail address, if you'd like to
receive a copy of the QBF sample that I mentioned.

Tom

QWaos168@XScom cast. Dnet (<--Remove all capitolized letters and spaces).

http://www.access.qbuilt.com/html/expert_contributors.html
_______________________________

:

G'Day Tom,
I see where you are coming from. You couldnt expect someone completely new
to the software to be able to do that straight away. I don't know much
actually when it comes to databases, and coding, but i have resorted to the
internet for any queries in design, relational database structure problems,
and, until a little while ago, QBF's. I dont disagree with purchasing a book
on the program, i have done so with many apps before. But i know i would
prefer to be told by someone how to do something rather that refer to a 500
page book, where there's usually 2 pages of relevancy to the task, and would
probably only use once. The link seemy dodgy, but its good for plain copy,
paste and edit, change a setting or 2, and with a little trial and error, i
had the search function in my database in minutes.