Question Searching the database

[rommelgenlight]

Hi, I am a user of ms access. I am planning to make table where I can input a memo type field for texts informations. I know that a memo type field can hold more than 65000 characters. i know that query can give me a result when I search base on my criteria.

Is there any other way to create a search engine other than using query?

Can you tell me how? thanks.

 

[HiTechCoach]

You could use brute force to read every record and use VBA code to parse the data.

Without any explanation of what you are doing, it will be very difficult to give you any kind of direction/advice.

What are you trying to do that a query will not work?

 

[rommelgenlight]

for example I have this one table which has two fields: mypage (memo type) and myID (number) and the latter field contains almost 1 page of short size bond paper information. for example this field contains the name or text "criticism", the seach engine will show the MyID with all the hits searched.

or I may say, its like a Windows Help windowed type help search utility

 

[HiTechCoach]

See if this example on my site is close to what you want:

Universal Search on many text with details

 

[rommelgenlight]

thanks hitechcoach. I appreciate this. though probably this is not what's in my mind but I will get the idea how you do this and make my own to solve my problem. thank you very much for your assistance.

 

[rommelgenlight]

by the way hitechcoach I saw your website SEACH A DOCUMENT, that is what's in my mind. can you teach me how to do that in access. you have dont that in your website.

 

[HiTechCoach]

by the way hitechcoach I saw your website SEACH A DOCUMENT, that is what's in my mind. can you teach me how to do that in access. you have dont that in your website.

Sure, see the example in the link I provided.

Searching is normally dong using a query (SQL). Thats is what queries are great at doing. My site uses a query.

The example I provided works basically just like a web site search. The difference is that most web searches are easy because they need very few fields. A database application usually has many fields that you may want to search. The example I gave does a database wide search! Which is a very cool! You could modified the example to search just the tables/fields you want. I understand it is not an exact solution for you needs, but it does have everything you and most people will need to learn how to search.