Search results

Now I got a new problem....:banghead: I've made a from with two combo boxes to find something easier. The problem is, if I added the form (name is: TestComboBox1) to the navigation form it doesn't work anymore. I get an error like: enter parameter value "Forms!TestComboBox1!cbosuppliertest How...

Sorry, still don't understand what to do first....:banghead: Sorry that i'm not understanding very well Maybe you can help me by step by step? Or show me in the access file what i've attached?

Now I have another question. Don't know if i should make a new thread.... Everything is now search as you type and it's filters very detailed. That's very nice for me and others who knows what to search. I was thinking about to creating a multiple "combo boxes" that are connected to each...

Thanks it's works:D

Yes i've changed "OR" to "AND" And it works perfect:D

Thanks it works!! :D :D One more question, if I search under category and type only the word "Holder" gives me 8 hits But it should be 9 hits because one of the cell contains "Electronic / Holder" How can i fix this? Thanks a lot I've attached the file again with a small update in the first...

Oke I will do it. So if you form Test Result then you get to see 5 different search bars. What I want is for example: --Product Name: Dev --Category : Elektronic --Color : White Should give result: 1 only (DevBg2, elektronic, White) that's good.... But I can't get it done like this. If I type...

Anyone who can help me with the problem what we've talked about?? Please help me I'm stuk:banghead::confused:

Oke now i think i've correct them like this Code: Private Sub Opentheform_Click() Dim sFilter As String sFilter = "" If Trim([txtproductname]) <> "" Then If sFilter <> "" Then sFilter = sFilter & " or " sFilter = sFilter & "( [productname] Like '" & [txtproductname] & "*' )" End...

No I don't have a separate "open the form" button But I've create one and named "opentheform in property sheet Then I've copied your code like this: And I get a error: block if without end if I only want users to search in this case... I made a form with 5 search bars to search specific item...

Doesn't give any error. But it doesn't work either:(

For two search bars it works great!! But what code do i need t use if i want use like six search bars...? code like this??: DoCmd.OpenForm "Product_DS", acNormal, , "[productname] Like '" & Me.txtproductname & "*' Or [category] Like '" & Me.txtcategory & "*' or [test3] Like '" & Me.txttest3 &...

Thanks a lot!! I can continue :)

Hello i'm using an query based search form in a navigation form. But i'm getting stuck with searching with multiple keywords. like i have 3 different search bars, where you can search very specific. Product name:........ category:....... compound:........ Code i'm using for only 1 keyword...

Hello everyone, I'm new to Access, never work with it before. Just started working with Access a week ago by searching and watching youtube videos. Also i've zero experience in programming. I'm a beginner so please be patient with me and i'm sure i have a lot of question coming up soon. I'm...