How Do I: Create a Search Form?
Top Comments
All Comments (39)
-
This is great except I want to look up just one number from a database and do a calculation on it. How can I do it without using the query builder? All I want to do is have a user enter the number of miles and then look up the price that corresponds to (less than or equal to) a number of miles in the database.
-
@egymke0 problem solved..thanks~~
-
Adding a powerful custom search engine to your website truly enhances the user experience. We've made it very easy to implement on your website by removing all the hassles of development, maintenance, and hardware requirements. Visit getwebsitesearch(dot)com for more info.
-
Is there anyway to create a query to search more than one column? for ex. search last name, first name and address? thanks
-
Easy to use ? not name of value when use access so
"WHERE [filed name] LIKE '%' + ? + '%' so you can get asking about what '?'.
-
@egymke0 i am having the same problem as u..how u solve it?
-
Problem of Like @Searchpara become to '@Searchpara' and get nothing
if you are used old Access not SQL you have to do like
LIKE '%' + ? + '%'
it is work with me for any query please connect with me
-
very usefull.... plz keep posting......... thanks
-
i am having the same problem. The system changes LIKE @Last_Name + '%' to LIKE '@Last_Name' + '%' . what should i do in order to fix it??
-
dont you fucking hate videos that require you to see a first one? youtube needs to make an option to set videos as part of a series and only show the first one in searches and suggested vids
@TheFlop123456 Dude it did that to me too,but guess what in the LIKE section you have to put a space like this LIKE @tablename +'%' instead of just putting the LIKE and the @ together like this LIKE@<-----that one is a no no.Stupid sintax i research that the whole day....
benjafut 1 year ago 4
Great! Thanks!
WayneTheClutch 2 years ago 2