Hi, I need to build an MS Access database and include abstracts and articles. I then need to retrieve this information using Visual Basic. I would like to design it so that when someone types in a word in a search facility then relevant info would appear just like in Google ie. not just the keyword but a few lines. Please can you help Thanks Richard

10 Years
Discussion Span
Last Post by debasisdas

Ive done it in access itself, not with VB.

In access I made a query and made the SQL starement so it said SELECT (whatever fields) from (tablename) WHERE (search field) LIKE (searchterm)

searchterm was supplied by the user and the output of the query was displayed in a report

in my case, i was searching a libary database for books by title


Hi, that is great thanks. Could you possibly tell me what was the searchterm used to give me some idea how I should phrase my search term thanks Richard


Okay, so in my database I had a table saying:

BookID (Key)

In MS Access the query was:

SELECT books.BookID, books.BookName, books.BookPrice, books.SampleChapter
FROM books
WHERE (((books.BookName)=[Enter Book Name]));

In MS Access [Enter Book Name] presents the user with a dialog biox asking that question.

I then used the result of the query to make a report showing the books and thier details, which were similar to the search term

Im sure you could do the same thing in VB6 quute easialy.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.