Search results

thats what im going to do. but if ever you will revise your sample database in accordance to my question please let me know ;) :p

yes correct, i could see CALCULATING...... maybe thats the reason why, right? but how can i eliminate this because its kinda disturbing that it is blinking whenever i search for a record. by the way, my database has calculation involved in other column fields.

maybe John, maybe. but i am new to Access and i have very little knowledge about programming/coding, hahaha... im dead! :banghead: but i wont give up! :)

its a great database actually but it doesnt apply to mine. John's database got my problem at least but it cannot search multiple keywords, same as your database. i tried your database and searched for : "pineapple fruit" or "fruit pineapple" it SHOULD give me a result (second record), but it...

i have the same problem with you guys. i wanted my search function to search multiple keywords that is in my database, for example keyword1 + keyword2 + keyword3 = can still search ; even if you mix the keywords can still give results. please let me know if you solve this problem. thanks a lot!

my database lag whenever i start searching, not really bad but i could notice that it blinks whenever i press a key on my keyboard. computer has a big ram (4gb), i5, with 500gb HDD... lots of free space. the database file is only 6.9MB... maybe there is a code that disable or makes the...

i have found this by searching the forum: http://www.access-programmers.co.uk/forums/showthread.php?t=234296 nice tips though... :)

having the same problem with you also. it is like, MS-Access lacks on security side. anyone can edit or change the database if they know something about MS-Access. will keep an eye to this thread for some answers.

youre in the right forum. you could get lots of ideas here, suggestions, advices, and even samples to download. enjoy your stay and welcome aboard! im new to MS-Access also and im making databases for a project. this site helped me a lot.

Welcome Jhun. I am new to MS-Access also. this forums will help you for sure. enjoy your stay!

so John Big Booty or any members here, any ideas how to do it about adding records to a form and will be saved to the database instead to a table of the navigation pane? i still didnt figure it out how to do it. any help is highly appreciated. thanks. note: im a beginner to ms-access

okay i got it. i will be going back to my thread =)

ops my bad. its not working, i thought i got it. sigh! i tried searching 3 keywords in a jumbled positions (even in order); like Australia (countryname), Angove's (winery), and SA (state), then no item/s found.

kipcliff, u know something about my question? : http://www.access-programmers.co.uk/forums/showthread.php?t=234384

yes i found the solution already - i will call it multiple dynamic search term not single only since it can search 2-5 keywords or any number of keywords that are in the database. but i cant post it back since the thread which you posted that sample is closed already. thank you so much John...

by the way, i found the solution already but i did it manually. i added a column in a table that includes ALL information but i hide it in the database so no one can see it. so if someone will search for single keyword item will appear if they will search for multiple keywords it will also...

i will set an example: search keywords: Australia Angove's if i will search for Australia (Countryname column) PLUS Angove's (Winery column) in the database it wont appear. its possible that users will search for specific Winery's name in Australia. for small database like your sample, two...

yes i got it but is it possible not to focus on single dynamic search only? sorry but i am new to MS-Access, i am still struggling here. been reading lots of resources for the project that i am into.

thanks John Big Booty. will try to check the resources you have given. i was following your replies here and i even got one of your samples - Dynamically search multiple fields ... but i have a slight problem about it, it will only search for 1 column, right? how about 2-3 columns like...

Hello everyone, i need help here, sniff sniff. i am creating a database about hundreds of equipment and materials. to cut the story short, i need to create a form that will add information (fields are: size, price, description, vendor name, etc.) or specification of each equipment and...