How Do I: Create a Search Form?

[pinmedownbaby]

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.

[WebsiteSearch]

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.

[drummerboyz24]

Is there anyway to create a query to search more than one column? for ex. search last name, first name and address? thanks

[egymke0]

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

[elmo89]

@egymke0 i am having the same problem as u..how u solve it?

[egymke0]

@elmo89

Easy to use ? not name of value when use access so

"WHERE [filed name] LIKE '%' + ? + '%' so you can get asking about what '?'.

[elmo89]

@egymke0 problem solved..thanks~~

[mithunmaddy9]

very usefull.... plz keep posting......... thanks



[EsmailiMokaram]

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??

[aGruntNamedYayap]

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

[JoDex9114]

I have an eror... "The Dataset it not part of the form"... what should i do???

[fortizsolutions]

Hi, Im Having the same problem i put the code like this: LIKE @LastName + '%', but the system change it to: LIKE '@LastName' + '%' ..Why is this happening??

And when I execute the query nothing happend...Please Help!!!

[fortizsolutions]

Hi, Im Having the same problem i put the code like this: LIKE @LastName + '%', but the system change it to: LIKE '@LastName' + '%' ..Why is this happening??

[RyggTonning]

visual basic 2005? you made this video in 2009... :P

[aReZz09]

can i filter data by multiple column...

[aReZz09]

can i filter by multiple column

[Aqwert76]

Anybody knows how to make a search tool for inside a file in VB? Please reply, i would really apprechiate it

[ytbisshit]

Hi am using visual studio 2008 but the problem is I dont get that pop up to test the query.... what am I doing wrong? And I am sure it is not my computer because I tried it on a computer of a friend.... the same story. Pls help... I need that to function.

thanks in advance...

[djdynz]

@ytbisshit did you find any answer to this problem?

[djdynz]

@ytbisshit did you find any answer to this problem?



[aglaiaPiraktiri]

When I execute the query, doesn't appear this new window, that allow me to try the query.... why?

[03212870845]

Grrrrrrreat... Post Thanx a lot....

[cynras]

anybody knows which video was the first ??

[un1ted4rmy]

How do I add a text box?

[koelhofull]

how do i do this thing with Microsoft Access???? please, help me

[Hardeep0014]

i having problems with this

as i type LIKE @Genre + %'

when i click out it changes to LIKE '@Genre + %'

n whn execute querry nothing appears??

[Hardeep0014]

@Hardeep0014 

soz i mean i type LIKE @Genre + '%'

[03212870845]

@Hardeep0014 its a wrong query.. try it LIKE @ Genre + '%'

[aglaiaPiraktiri]

@03212870845 That happened to me also! It doesn't recognize that code!

[03212870845]

@aglaiaPiraktiri listen dear can u plz tel me what r u using to creat a search form (Visual basic6 or visual studio ? )

[WayneTheClutch]

Great! Thanks!

[TheFlop123456]

I get no textbox where you can insert a search thing, why?

[benjafut]

@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....

[un1ted4rmy]

@TheFlop123456 Same thing for me too...

[MyRaqTV]

try using microsoft access, same process...

Great video though...