Search is not found

%3CLINGO-SUB%20id%3D%22lingo-sub-2391717%22%20slang%3D%22en-US%22%3ESearch%20is%20not%20found%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2391717%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20come%20when%20I%20go%20to%20'Search'%20for%20a%20key%20word%2C%20I%20get%20nothing.....though%20I%20have%20those%20words%20in%20my%20Database%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2391717%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2393634%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20is%20not%20found%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2393634%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1064066%22%20target%3D%22_blank%22%3E%40cf24_%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fwww.gpcdata.com%2FGPGOnAccess%2F%3FTopicID%3D6%26amp%3BTopic%3D%26quot%3Banything%26quot%3B%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EWe%20would%20have%20to%20know%20a%20great%20deal%20more%20about%20this%20relational%20database%20applicatio%3C%2FA%3En%20to%20hazard%20any%20kind%20of%20guess%2C%20starting%20with%20%22HOW%22%20you%20go%20about%20doing%20this%20search%3F%20Given%20the%20fact%20that%20there%20is%20at%20least%20one%20built-in%20search%20facility%20and%20it%20is%20possible%20to%20create%20VBA%20functions%20of%20many%20different%20sorts%20to%20%22search%22%2C%20the%20options%20are%20sort%20of%20wide%20open.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2393862%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20is%20not%20found%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2393862%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F126074%22%20target%3D%22_blank%22%3E%40George%20Hepworth%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20attached%202%20screen%20shots%20of%20where%20I%20do%20the%20'searching'%20for%20key%20words.%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20using%20the%20template%20that's%20in%20Access%20called%20Contacts%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2394101%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20is%20not%20found%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2394101%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1064066%22%20target%3D%22_blank%22%3E%40cf24_%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20screen%20shots.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20first%20image%20shows%20what%20appears%20to%20be%20a%20custom%20search%20function%20in%20that%20relational%20database%20application%20template.%20I'd%20have%20to%20download%20and%20install%20it%20to%20know%20how%20it%20works%20and%20also%20have%20the%20same%20sample%20data%20you%20are%20using.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThe%20second%20image%20shows%20the%20built-in%20search%20function.%20Note%20that%20it%20has%20several%20options%2C%20each%20of%20which%20effects%20the%20performance%20and%20outcome%20of%20the%20search.%3C%2FP%3E%3CP%3EFor%20example%2C%20it%20is%20searching%20%22current%20field%22%20which%20means%20that%20it%20is%20only%20going%20to%20find%20matches%20in%20whichever%20field%20has%20the%20focus%20at%20the%20point%20you%20invoke%20the%20search.%20If%20that%20field%20is%20the%20one%20in%20which%20you%20expect%20to%20find%20%22tastee%22%20it%20will%20do%20that%2C%20subject%20to%20the%20second%20option%2C%20which%20is%20%22whole%20field%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22Whole%20Field%22%20means%20only%20the%20exact%20word%20%22tastee%22%20will%20match%20and%20if%20there%20is%20no%20instance%20of%20that%206-letter%20string%2C%20but%20there%20is%20a%20value%20of%2C%20say%2C%20%22tasteetreat%22%2C%20that%20won't%20match.%20That%20could%20also%20impact%20the%20search%20results.%20If%20you%20change%20that%20to%20%22Any%20Part%20of%20Field%22%2C%20that%20might%20return%20the%20value%20you%20think%20you%20should%20find%20but%20don't.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

How come when I go to 'Search' for a key word, I get nothing.....though I have those words in my Database?

3 Replies

@cf24_ 

We would have to know a great deal more about this relational database application to hazard any kind of guess, starting with "HOW" you go about doing this search? Given the fact that there is at least one built-in search facility and it is possible to create VBA functions of many different sorts to "search", the options are sort of wide open.

 

 

 

 

@George Hepworth 

I've attached 2 screen shots of where I do the 'searching' for key words. 

I'm using the template that's in Access called Contacts

@cf24_ 

Thanks for the screen shots. 

The first image shows what appears to be a custom search function in that relational database application template. I'd have to download and install it to know how it works and also have the same sample data you are using.


The second image shows the built-in search function. Note that it has several options, each of which effects the performance and outcome of the search.

For example, it is searching "current field" which means that it is only going to find matches in whichever field has the focus at the point you invoke the search. If that field is the one in which you expect to find "tastee" it will do that, subject to the second option, which is "whole field".

 

"Whole Field" means only the exact word "tastee" will match and if there is no instance of that 6-letter string, but there is a value of, say, "tasteetreat", that won't match. That could also impact the search results. If you change that to "Any Part of Field", that might return the value you think you should find but don't.