Searchable Access Database? Please help!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access database that contains many Hyperlinks. Instead of scrolling
through this document, I would like the user to be able to search it. For
instance, when the user opens the document it says, "What is your question?"
The user types their question and hits SUBMIT. The system searches the Access
the database and ONLY displays the relevant results. The same concept as a
search engine but I only have one document to search.

I understand that there are many tutorials on this subject. However, they
are too technical for me. I've read a few and still don't understand what to
do. Please keep it as simple as possible.

I do have Office 2003 Professional. I also have HTML tools such as
Dreamweaver and Flash MX. Again, I am a novice when it comes to all computer
programs so please keep it simple.

Any information that you can provide will be greatly appreciated. Thanks!
 
Adam

See comments/questions in-line below...
I have an Access database that contains many Hyperlinks. Instead of scrolling
through this document,
Click to expand...

What document? An Access database consists of tables, with data, forms
displaying that data, queries to lookup that data, and reports to print it
out. (It's more complex, but that's a good start.)
I would like the user to be able to search it.
Click to expand...

"It?" The document? What document? Are you saying that each hyperlink
points to a different document?
For
instance, when the user opens the document it says, "What is your
Click to expand...
question?"

I'm still confused ... How can the user open a document before they know
which one they're looking for?
The user types their question and hits SUBMIT. The system searches the Access
the database and ONLY displays the relevant results.
Click to expand...

"... types their question..." sounds like free-form English language search.
I'm not aware of any built-in function that Access has (at least in earlier
versions) that lets you type in, say "what color are maple trees?" and
"understands" enough to go searching for a response.
The same concept as a
search engine but I only have one document to search.
Click to expand...

We're not there, so we can't see what you're looking at. Can you explain
more about the "one document"?
 
Typically it's not done this way. The usual search is through keywords. The
user enters one or more words, specifies "all words", "exact words", etc
(you have probably seen this type of search), presses submit and the
database dispays the relevant results. Look at the Google site as a good
example of this.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

If you don't get the help you need in the newsgroup, I can help you for a
very reasonable fee.
Over 1000 Access users have come to me for help.
Remember that a lone man built the Ark. A large group of professionals built
the Titanic.
 
Jeff,

Thanks for the reply. It is one Access document that contains hundreds of
questions, which are also hyperlinks. Every hyperlink points to a separate
document. Each one has it's own cell. Here is how it works:

User has a question. They open the Access document and scroll through the
listed questions. When they find the one that relates to their question, they
click on the question and a Flash document pops up to walk them through the
answer.

Instead of scrolling through the questions, I would like to add a search
feature so that only the relevant questions are listed. So, if I did a search
on "maple trees", it would display the following:

What color are maple trees?

I know that this function exists as I've seen others with it. I think the
search function is an Infopath document that searches an Access document. It
then displays the relevant results.

Let me know if you have any more questions.
 
If you don't get the help you need in the newsgroup, I can help you for a
very reasonable fee.
Over 1000 Access users have come to me for help.
Remember that a lone man built the Ark. A large group of professionals built
the Titanic.
Click to expand...

These 1000 (if at all a real figure..) is only the result of
-- 4 years abusing the newsgroups.
-- 4 years blatantly advertising and job hunting.

You only care about making money, and you act as if the groups are your private hunting ground.
So why would ANYBODY ever trust a person like you and hire you?
********************************************************

Explanation and more on this answer to Steve:
http://home.tiscali.nl/arracom/stopsteve.html

Arno R
 
Adam

So, are you saying you want Access to search a list of text entries for
something like a "keyword" (e.g., "maple tree")?

If so, consider using a parameterized query with an expression in the
criterion "cell" something like:

Like * & [Enter your search term] & *

Note that this will NOT find the entry re: maple trees if the user enters
"tree, maple". This is NOT a generic, any word, any order search.
 
"Adam Haviland" <[email protected]> schreef in bericht
Adam,
I guess you have a datasheet-form with all the questions listed?
If so you can use a filter.
Suppose you make a search-textbox called "txtsubject" and the control that is bound to the questions is called "txtQuestion"

Create a button called "btnFilter"
You could do something like:

<air code, but free>
Sub btnFilter_Click()
Me.Filter = "txtQuestion Like '*" & Me!txtsubject & "*'
Me.FilterOn = True
end sub

Another button will clear the filter like:
Me.Filter = ""
Me.FilterOn = False

Arno R
 
Back
Top