DRC Forum » Personal Interests » Computers » Access problem! » Page 1 of 1

[|DRC| Death]

For my school work I have to do some database or other. It's about 5 a day basically. I've got a table with fields like name of fruit, colour group, calories and some other shit. I need to do a form (easy enough, done) then I need to add a text box and button (done) then I need to type something into the text box and press the button and it searches the table for whatever I put into the text box. Not done, that's where you come in.

Any ideas

[Sponsored Ad]

[|DRC| Iceman]

"Search" maybe?

[|DRC| Zyprexa]

I guess you're looking for an appropriate SELECT statement? If I remember right, wildcards are %. If you need something else, be more precise.

[|DRC| Death]

Right well basically I've got a table with hundreds of records that look like this:

Apple | red | 100 | 1

and some other weird shit where the first field is the name of the fruit/veg, the next is the colour group, next is calories, and next is quantity to account for 1 daily portion.

Now, I want a form where you could type in in a text box "Apple", press a button, and it "filters" for want of a better word the table to just show fruits with the word apple in it. (In the table there's about 4 different apples, apple juice, red apple, green apple) etc...

Another way of phrasing it would be if you went into a video store and the guy has a table full of his movies and you say to the guy on the counter I want a list of videos with Robert De Niro in for example and he types his name in and he gets something like this:

The Deer Hunter
Taxi Driver
Casino
Goodfellas

etc...

except I want the same thing for fruit/veg.

[|DRC| Zyprexa]

you have to tell us what the table columns are named. are you using PHP? Hit me up on Skype if you have the time. :-)

[|DRC| Death]

No PHP is being used. It's not being coded it's all done in access.

[|DRC| Zyprexa]

aaah. well sorry then, I don't know access. I thought you were making a website :-)

[|DRC| Death]

I didn't even bother reading the criteria.

Doesn't matter don't need to do it.

[|DRC| Zyprexa]

oh well...

[|DRC| Wartex]

You need an SQL statement and use a value from a search textbox as a variable in it.

sample table:

Code:

table_mytable fruit          color           calorie --------------------------------------------- Apple         |green          |100        | 1 tasty Apple   |red            |100        | 1 shitty apple  |brown          |0          |0

SELECT `fruit` FROM table_mytable WHERE fruit LIKE %apple%;

code example here http://www.thescripts.com/forum/thread188647.html
_________________