Search results

JR, Thanks again for your help. Now I have get two other questions: 1. (1) When searching the real database, I got some confused results. For example, When searching using single words, I got 217 records for “DNA”, 10 records for “PCR”. However, when searching with both words “DNA...

JR, Thank again for your help. I tested it in the samplebase, it works well. However, when testing on real database (which has the same datastructure as the samplebase, except there are a few more columns), it comes up with a massage: [run time error “94”, Invalid use of Null]. It happens...

JR, Thanks a lot for your kind help. Greatly appreciated! Now I have found another interesting issue ( a problem for me): Some partial word can produce search match (which is something I want to avoid). For example, if I enter a partial word for apple as a, app, appl, the program comes up...

davies107, You are very luck, and I have this problem solved by JANR (he/she is a great guy!!). see this for detail: http://www.access-programmers.co.uk/forums/showthread.php?p=1197319#post1197319 Good luck:p

JR, Thanks a lot for your fixes. After some testing, I find it works much better now. However, I still find a very weird situation: if I do a search with a string of words from record five ( which is: applepie and mushroom makes for apple and mushrooms), in many case, it shows up with “could...

JR, Attached is a samplebase, which is the same base you sent me, except that I changed the last record to “Meal and fish.”, in place of “Apple.” Now, when you enter any word of the last record, such as Meal, and, and fish, the program comes out a Run-time error “3021” no current record, no...

JR, I am testing the search program you wrote with my data. It works well. However. It comes up with a "run-time error'3021": no current record" message, when I enter a word "DNA". When I opened the debug window, the code .MoveNext is highlighted. Any way to fix the problem? Thanks Peter

JR, Thanks a lot for your kind help, and this is what I need exactly. Just one more question: as you said, the speed of search will become lower with increase data size. Do you have a idea for the searching time for a database with 100,000 memo fields, each have 300 words, for search for up to...

Janr, Thanks a lot. I test the program you send me, and it is exactly what I want. A only issue is that it can only process (search) one word a time. Is it possible to make it to process more than one word? for example, if I type apple, it comes up with four records. If I type apple (space)...

Hi All, I have a question that was put forwarded a few year again by lilanngel in the forum. I'm currently building a database to collect information on a bunch of books. Each book’s synopsis is entered as memo in the database. I want to add a search function so that people can find specific...

John, Thanks for your prompt reply. BUT what I need is a criteria that find the first record ONLY, not all of them, particularly record 2, which does not "apple". Criteria Like "*apple*" And Like "*pine*" locate record 2, not 3. Further more, using this type of criteria, using part of word...

Hi Lilanngel, While searching the forum, I found your post asking the exactly the same kind of question I want to ask...search book synopsis with key words to return book(s) containing the matched word(s). Very often, more than words will be keyed in to find the books closely related to the...

Hi Guys, Hi Guys, I need to your help in design of query in Access to find record containing fields with EXACTLY matched word(s). For examples, there are three records each containing a field with the following texts: Field 1: I have an apple. Field 2: I have a pineapple. Field 3...

Hi Guys, Do you have any idea as to how long it will take to process a query in a database with 100,000 records? Any relationship between the processing time and database size? Thanks, Peter